Accessing a Function

[Guest]

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]

Hi
you have to include the filename as well. so something like
=wjm.Library.XLS!your_function_name

 

[Guest]

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]

Hi
put your function in an *.xla addin and you should be able to use it
directly in your worksheet

 

[Guest]

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