Find folder macro was in

[Fred Smith]

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?

 

[mudraker]

fPath = ThisWorkbook.Pat

 

[A.W.J. Ales]

Fred,

If you take up this function in (all versions) of your macrofile, that
function will return the path of the (loaded) version of the file.
(NB Not tested)

Function MacroFilePath()
MacroFilePath = Workbooks("Persnlk.xls").Path
End Function

Ofcourse : Change persnlk.xls with the name of your macro file.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Robin Hammond]

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]

That's exactly it. Thanks for your help.