So, will this statement need to be at the start of each of the macros, the
macros open several files so will I need to type this in for each file that
will be opened? And then in the line of code that opens the workbook, will
it look like this;

Workbooks.Open Filename:= _
"\myfile.xls"

Thanks

"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