Sorry I didn't make my question clear. I want to write this code so that
regardless of where I put this workbook it will look to open the file in the
directory where the workbook exists.



"cucchiaino" wrote in message
...
properties wrote:
How can I rewrite this code to open a file named "invoice", in case I
move the workbook to another directory.

Workbooks.OpenText Filename:= _
"C:\Documents and Settings\Owner\My
Documents\\Project\Summary\Test_Macro\invoice"

Workbooks.OpenText Filename:= _
"C:\newdirectory\invoice"