Macro for opening worbooks

[lechev65]

Hi,

I use the below macro to open different worbooks in one folder.
***********************************************

Private Sub CommandButton2_Click()
Workbooks.Open Filename:="D:\Book2.xlsx"
End Sub

***********************************************
It works fine if I use it in the same computer but if I move the file with
the workbooks to another computer or different disk drive, I have to
modify every time the address of each macro.
Could you give me a hint how to modify the address "D:\Book2.xlsx" in
order the macro to look the folder and open the worbook in the folder,
regardless in which disk drive or computer the folder is.

posted also here: http://www.mrexcel.com/forum/showthread.php?t=639435

Thank you in advance.

Krasimir