Try something along the lines of ActiveWorkbook.Path.

"Edreams" wrote in
message ...

I have a macro that will always use another file in the same folder as
the macro file, however, the folder will vary depending on who is using
the macro.

Is there some way to automatically reference this folder, without user
input, and set it as a string or something so I can use the folder path
name?


--
Edreams
------------------------------------------------------------------------
Edreams's Profile:
http://www.excelforum.com/member.php...o&userid=28391
View this thread: http://www.excelforum.com/showthread...hreadid=479821