How to find the location of a Excel .xla file
 

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

How to find the location of a Excel .xla file
 

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.

--
More Excel ? www.rosenkrantz.nl or
-------------------------------------------------------------------

"Belinda" wrote in message
om...
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