Use thisworkbook.Path to get the path of the workbook containing the macro
and use it to open the desired file.

-------------------------------------
Pl. click ''Yes'' if this was helpful...



"jackrobyn1" wrote:

I have a simple macro in a workbook named "daily info" that activates when i
click a button, the macro opens a workbook called "Phonebook" both of these
workbooks are contained in the same folder called "my reports". What i need
is a macro that will look inside the folder called "my reports" even if i
move this folder to another place on my computer. In effect only looking
inside the immediate folder. I hope this makes sense.
Thanks for any help