Accessing a Function
I keep an XLStart file "wjm.Library.XLS" that opens automatically and
which I use to store macros I use in various programs. Simple Excel extensions I've created and use. Today I had a problem I wasn't clever enough to fix with a macro so I created a simple function with VBA in my library file. It works and tests ok from the library worksheet so now I'm ready to use it. For some reason, my real worksheet cannot find the function I created. Both worksheets are open, my library and my real work. It can find the macros I use, but not the new function. When I use it from my work file, I get the error #NAME? back. Is there something I need to do to tell the worksheet to look in the default library file to find this? Thanks... Bill |
Hi
you have to include the filename as well. so something like =wjm.Library.XLS!your_function_name -- Regards Frank Kabel Frankfurt, Germany "Bill Martin -- (Remove NOSPAM from address)" schrieb im Newsbeitrag ... I keep an XLStart file "wjm.Library.XLS" that opens automatically and which I use to store macros I use in various programs. Simple Excel extensions I've created and use. Today I had a problem I wasn't clever enough to fix with a macro so I created a simple function with VBA in my library file. It works and tests ok from the library worksheet so now I'm ready to use it. For some reason, my real worksheet cannot find the function I created. Both worksheets are open, my library and my real work. It can find the macros I use, but not the new function. When I use it from my work file, I get the error #NAME? back. Is there something I need to do to tell the worksheet to look in the default library file to find this? Thanks... Bill |
Frank Kabel wrote:
Hi you have to include the filename as well. so something like =wjm.Library.XLS!your_function_name Grumble, grumble.... That kind of eliminates a lot of the advantage of keeping one common default library file I guess -- if it doesn't default to it like the macros do. Thanks. Bill |
Hi
put your function in an *.xla addin and you should be able to use it directly in your worksheet -- Regards Frank Kabel Frankfurt, Germany "Bill Martin -- (Remove NOSPAM from address)" schrieb im Newsbeitrag ... Frank Kabel wrote: Hi you have to include the filename as well. so something like =wjm.Library.XLS!your_function_name Grumble, grumble.... That kind of eliminates a lot of the advantage of keeping one common default library file I guess -- if it doesn't default to it like the macros do. Thanks. Bill |
Frank Kabel wrote:
Hi put your function in an *.xla addin and you should be able to use it directly in your worksheet That does the trick! Thanks. Bill |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com