Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
I have a user that has about 10 custom functions. I'd like to create a
add-in to hold them and allow them to be used on any new or old spreadsheet he uses. Is an add-in the best way? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
scott
An add-in is a good way to go. Copy/paste the UDF's to a general module in a new workbook. Then FileSaveasSaveas File Type...scroll down to bottom of list and select Microsoft Excel Add-in(*.xla) Gord Dibben Excel MVP On Mon, 27 Dec 2004 16:25:40 -0600, "scott" wrote: I have a user that has about 10 custom functions. I'd like to create a add-in to hold them and allow them to be used on any new or old spreadsheet he uses. Is an add-in the best way? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
where do i place an add-in so it's always loaded? i didn't think that was
possible without manually adding the add-in. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... scott An add-in is a good way to go. Copy/paste the UDF's to a general module in a new workbook. Then FileSaveasSaveas File Type...scroll down to bottom of list and select Microsoft Excel Add-in(*.xla) Gord Dibben Excel MVP On Mon, 27 Dec 2004 16:25:40 -0600, "scott" wrote: I have a user that has about 10 custom functions. I'd like to create a add-in to hold them and allow them to be used on any new or old spreadsheet he uses. Is an add-in the best way? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
You need to load this addin only once. Then next time it will load
automatically. It is also possible to load the add in programatically. Regards, Shetty. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
Save the xla in the XLStart folder & it will be loaded automatically - very
similar tio the personal.xls workbook that many people like to use. If you have an alternative start up folder - see under Tools/Optios - then you could put the XLA there instead. Both these can be used, or indeed, simply use the Add-In Manager - Tools/Add-Ins "scott" wrote: I have a user that has about 10 custom functions. I'd like to create a add-in to hold them and allow them to be used on any new or old spreadsheet he uses. Is an add-in the best way? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
thanks, that is exactly what i need.
"Patrick Molloy" wrote in message ... Save the xla in the XLStart folder & it will be loaded automatically - very similar tio the personal.xls workbook that many people like to use. If you have an alternative start up folder - see under Tools/Optios - then you could put the XLA there instead. Both these can be used, or indeed, simply use the Add-In Manager - Tools/Add-Ins "scott" wrote: I have a user that has about 10 custom functions. I'd like to create a add-in to hold them and allow them to be used on any new or old spreadsheet he uses. Is an add-in the best way? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
How can I load an add-in via code? I thought that was not possible.
"Shetty" wrote in message oups.com... You need to load this addin only once. Then next time it will load automatically. It is also possible to load the add in programatically. Regards, Shetty. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
Check the Installed property of the Addin object.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How can I load an add-in via code? I thought that was not possible. "Shetty" wrote in message oups.com... You need to load this addin only once. Then next time it will load automatically. It is also possible to load the add in programatically. Regards, Shetty. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions | Excel Discussion (Misc queries) | |||
User Defined Functions | Excel Programming | |||
user defined functions | Excel Programming | |||
user defined functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |