Open file in directory
 

Hi. The following code will open a file in a specific
directory. After I complete the development of this
file, I plan to move it along with the other file to
another computer. At this point, I don't know the entire
path on the new computer, but I do know that both files
will reside in the same directory.

How would I rewrite this line so that it will open the
file in the same directory as that which the macro file
is located?

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mike\My
Documents\Demos Log file.xls"

Thanks,
Mike.

Open file in directory
 

Workbooks.Open Filename:= _
ThisWorkbook.Path & "\" & "Demos Log file.xls"

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
Hi. The following code will open a file in a specific
directory. After I complete the development of this
file, I plan to move it along with the other file to
another computer. At this point, I don't know the entire
path on the new computer, but I do know that both files
will reside in the same directory.

How would I rewrite this line so that it will open the
file in the same directory as that which the macro file
is located?

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mike\My
Documents\Demos Log file.xls"

Thanks,
Mike.

Open file in directory
 

Thanks, Tom.

-----Original Message-----
Workbooks.Open Filename:= _
ThisWorkbook.Path & "\" & "Demos Log file.xls"

--
Regards,
Tom Ogilvy

"Mike" wrote in
message
...
Hi. The following code will open a file in a specific
directory. After I complete the development of this
file, I plan to move it along with the other file to
another computer. At this point, I don't know the
entire
path on the new computer, but I do know that both files
will reside in the same directory.

How would I rewrite this line so that it will open the
file in the same directory as that which the macro file
is located?

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mike\My
Documents\Demos Log file.xls"

Thanks,
Mike.




.