How I know if a file is using a custom addin

[Rodrigo Ferreira]

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]

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]

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]

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/mi...e24ab?lnk=st&q=&rnum=1&hl=en#c9502712bf5e24ab

or
http://snipurl.com/wghm