Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
I want to create UDFs that I can use in any of my applications just like
ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
put them in a module in a new workbook then save as an XLA ( Excel Add-In)
save this in the default STARTUP location so that it loads whenever excel starts. "Hershmab" wrote: I want to create UDFs that I can use in any of my applications just like ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
Patrick,
I followed your suggestion and saved the new workbook as an XLA in ....\Documents and Settings\....\Excel\XLSTART\UDF.XLA, where it opens up automatically just as PERSONAL.XLS does. But the name of the UDF that I originally wrote in PERSONAL and transferred to the new .XLA is now not recognized. PS I am using Excel 2003 under Windows XP SP2 - if that is relevant. "Patrick Molloy" wrote: put them in a module in a new workbook then save as an XLA ( Excel Add-In) save this in the default STARTUP location so that it loads whenever excel starts. "Hershmab" wrote: I want to create UDFs that I can use in any of my applications just like ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
What does not recognized mean?
Did you remove the code for the UDF from personal.xls? (If you didn't, then try deleting it. Remember to save the .xls file.) Does the formula still point at personal.xls? (Edit|Links and point to the new addin) If you reenter the formula, does it work ok? If you type the formula into an empty cell in a new test workbook, does it work ok? Hershmab wrote: Patrick, I followed your suggestion and saved the new workbook as an XLA in ...\Documents and Settings\....\Excel\XLSTART\UDF.XLA, where it opens up automatically just as PERSONAL.XLS does. But the name of the UDF that I originally wrote in PERSONAL and transferred to the new .XLA is now not recognized. PS I am using Excel 2003 under Windows XP SP2 - if that is relevant. "Patrick Molloy" wrote: put them in a module in a new workbook then save as an XLA ( Excel Add-In) save this in the default STARTUP location so that it loads whenever excel starts. "Hershmab" wrote: I want to create UDFs that I can use in any of my applications just like ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
Try going to Tools Add-Ins and installing the add-in.
--JP On Oct 8, 12:07*pm, Hershmab wrote: Patrick, I followed your suggestion and saved the new workbook as an XLA *in ...\Documents and Settings\....\Excel\XLSTART\UDF.XLA, where it opens up automatically just as PERSONAL.XLS does. But the name of the UDF that I originally wrote in PERSONAL and transferred to the new .XLA is now not recognized. PS I am using Excel 2003 under Windows XP SP2 - if that is relevant. "Patrick Molloy" wrote: put them in a module in a new workbook then save as an XLA ( Excel Add-In) save this in the default STARTUP location so that it loads whenever excel starts. "Hershmab" wrote: I want to create UDFs that I can use in any of my applications just like ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae?- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
If the addin is in the XLStart folder, it doesn't need to be installed. It'll
open when excel starts normally. JP wrote: Try going to Tools Add-Ins and installing the add-in. --JP On Oct 8, 12:07 pm, Hershmab wrote: Patrick, I followed your suggestion and saved the new workbook as an XLA in ...\Documents and Settings\....\Excel\XLSTART\UDF.XLA, where it opens up automatically just as PERSONAL.XLS does. But the name of the UDF that I originally wrote in PERSONAL and transferred to the new .XLA is now not recognized. PS I am using Excel 2003 under Windows XP SP2 - if that is relevant. "Patrick Molloy" wrote: put them in a module in a new workbook then save as an XLA ( Excel Add-In) save this in the default STARTUP location so that it loads whenever excel starts. "Hershmab" wrote: I want to create UDFs that I can use in any of my applications just like ordinary Excel worksheet functions. I have found that if I place the module(s) in Personal.xls I have to prefix the function name by that workbook name. Is there somewhere else to put them so that I can use the bare function name in any formulae?- Hide quoted text - - Show quoted text - -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
Interesting. But the OP appears to have done that and it didn't work.
So my thought was it still has to be registered as an add-in. --JP On Oct 8, 3:39*pm, Dave Peterson wrote: If the addin is in the XLStart folder, it doesn't need to be installed. *It'll open when excel starts normally. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
To all the responders: thanks very much. No one answer solved the whole
problem, but the combination, supplemented by looking up a vast VBA reference book, did the trick! "JP" wrote: Interesting. But the OP appears to have done that and it didn't work. So my thought was it still has to be registered as an add-in. --JP On Oct 8, 3:39 pm, Dave Peterson wrote: If the addin is in the XLStart folder, it doesn't need to be installed. It'll open when excel starts normally. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place UDF modules for general use
Why not share the solution -- it may make it easier for another victim!
Hershmab wrote: To all the responders: thanks very much. No one answer solved the whole problem, but the combination, supplemented by looking up a vast VBA reference book, did the trick! "JP" wrote: Interesting. But the OP appears to have done that and it didn't work. So my thought was it still has to be registered as an add-in. --JP On Oct 8, 3:39 pm, Dave Peterson wrote: If the addin is in the XLStart folder, it doesn't need to be installed. It'll open when excel starts normally. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming |