Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 - How to find cell location of a link to another file? | Excel Discussion (Misc queries) | |||
From Macro in Excel find cursor location eg.C7 | Excel Discussion (Misc queries) | |||
Excel 2003: cannot find default file location | Excel Discussion (Misc queries) | |||
i couldn't open my excel files,it gives location couldn't find err | Excel Discussion (Misc queries) | |||
Find/Replace Linked Cells Prompts File Location | Links and Linking in Excel |