Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating add-ins
How do you create add-ins?
I made several functions which I plan to use often and I don't want to copy or import the Modules to every workbook I'm working on. It seems that if I make an add-in, the functions will be usable in every workbook. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating add-ins
jomni
you could start here... http://support.microsoft.com/default...NoWebContent=1 -- XL2002 Regards William "jomni " wrote in message ... | How do you create add-ins? | I made several functions which I plan to use often and I don't | want to copy or import the Modules to every workbook I'm | working on. It seems that if I make an add-in, the functions | will be usable in every workbook. | | | --- | Message posted from http://www.ExcelForum.com/ | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating add-ins
Hi Jomni!
Open a new workbook. Copy and paste your VBA code to modules in this new workbook Delete all except one worksheet File Save As Give a file name without any extension From the File Type drop down select "Microsoft Excel Excel Addin" [It's right down the bottom] OK The best place to store the Addin will be in the Library file. This is variously located but here's a typical location: C:\Program Files\Microsoft Office\Office2003\OFFICE11\Library If you put it there, Excel will read it into the Addin dialog the next time Excel is opened (note that you won't see it there immediately after saving from within Excel and you have to close and re-open first). -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a new key | Excel Discussion (Misc queries) | |||
creating Yes,No | Excel Discussion (Misc queries) | |||
Creating IF with OR | Excel Worksheet Functions | |||
creating a pdf | Excel Discussion (Misc queries) | |||
Creating | Excel Discussion (Misc queries) |