Get directory path where macro was opened manually.

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.