View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Find folder macro was in

Fred,

If you mean, can the macro determine it's own location, yes. Use
thisworkbook.path.

If you mean something else, you'll need to explain...

HTH,

Robin Hammond
www.enhanceddatasystems.com

"Fred Smith" wrote in message
...
I have all my macros in one file. I run them from a custom menu item.
However, depending on the computer the macros are run on, the folder the
file is loaded from could be different.

Is it possible to determine the folder the macro file was loaded from?

--
Regards,
Fred
Please reply to newsgroup, not e-mail