Marie,
This should not affect you since you're opening an existing file. But when
you start a NEW file (File | New) it has no path, since it hasn't been saved
to disk yet. Saving such a file in code results in a save to the current
directory (usually your My Documents folder).

Just thought I'd mention that.

"Marie Bayes" wrote:

Thanks Richard

"RichardSchollar" wrote:

Hi Marie

You need the following where you have the workbook open statement:

Workbooks.Open ThisWorkbook.Path & "\" & YourWorkbookName

Then this will always open the file named "YourWorkbookName" in the
same directory as the workbook that holds the macro code.

Hope this helps!

Richard




On 25 Jan, 08:13, Marie Bayes
wrote:
Hi
Is there any code I can put into my macro (which opens a file) that will
always look for the file in the 'current' directory, ie, the directory that
the original file was opened in, so that if I move the directory it will
always find it?
Thanks in advance