How to find the location of a Excel .xla file

  • Thread starter Thread starter Belinda
  • Start date Start date
B

Belinda

Hello All

I am working with a 3rd party .xla and I need to load that to access
the macros defined within this .xla file. But my problem is this .xla
is not registered in Excel > Tools > Addin it is run by users from the
Start Menu shortcut to the .xla.

Can any of you please provide a code for searching the location of
this .xla on the disk and loading it from that path determined.

Thanks
Belinda
 
Belinda;

You don't need code.

Do that with Explorer.
Search for *.xla and do so in all directories including system and hidden
directories.
You should then find it.

Mark.
 
Back
Top