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.