When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?

Rodrigo Ferreira

You mean like a UDF (from a formula in a cell)?

Edit|Links and look.

If you mean subroutines, I think you'll have to look through the code.

Rodrigo Ferreira wrote:

When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?

Rodrigo Ferreira

--

Dave Peterson

I'll try to explain:
I created "RodrigoAddin.xla" with the function called "Test()" (this file
has other functions)
I have other file: Anything.xls and when I open it, I wanto to know if this
XLS use the function "Test()" (or other function from RodrigoAddin.xla)

How can I kwnow if any other file use some function from my custom XLA?

Sorry for my poor english

Rodrigo Ferreira



"Dave Peterson" escreveu na mensagem
...
You mean like a UDF (from a formula in a cell)?

Edit|Links and look.

If you mean subroutines, I think you'll have to look through the code.

Rodrigo Ferreira wrote:

When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?

Rodrigo Ferreira

--

Dave Peterson

If you open anything.xls, you can use Edit|links to check.

If you're looking for a list of workbooks that use functions in your addin, then
there's nothing built into excel that allows you to know.

You could open each workbook that you own (on your harddrive, all your network
drives, all your CDs, all your DVDs, all your thumbdrives, all your floppy
drives....) and check, though.

Here's a routine that opens all the files in a specific folder to look for a
link to a specific workbook.

http://groups.google.co.uk/group/mic...2712bf 5e24ab

or
http://snipurl.com/wghm



Rodrigo Ferreira wrote:

I'll try to explain:
I created "RodrigoAddin.xla" with the function called "Test()" (this file
has other functions)
I have other file: Anything.xls and when I open it, I wanto to know if this
XLS use the function "Test()" (or other function from RodrigoAddin.xla)

How can I kwnow if any other file use some function from my custom XLA?

Sorry for my poor english

Rodrigo Ferreira

"Dave Peterson" escreveu na mensagem
...
You mean like a UDF (from a formula in a cell)?

Edit|Links and look.

If you mean subroutines, I think you'll have to look through the code.

Rodrigo Ferreira wrote:

When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?

Rodrigo Ferreira

--

Dave Peterson

--

Dave Peterson