Get directory path where macro was opened manually.

[welchs101]

Hi,

I have a macro. I open the macro manually from a location on the hard-drive. From the macro i want to save some data to the same location that the macro was opened from.

Any ideas?

Manually, if i do a save as the location of where i opened the macro from comes up but how do i get this location from the macro? Any thoughts.

[welchs101]

found something on this site from another article which works

Please Login or Register  to view this content.

the above code gives the directory / path from which the macro was opened.