How to find the location of a Excel .xla file

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
 
M

Mark Rosenkrantz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top