I have written the following code to open a file:

Workbooks.Open Filename:=CurDir & "\FILENAME.XLS"

This was created in a folder on my hard drive, but now that I have moved
everything to a network drive I get errors saying that the file does not
exist because the location is still saved as my hard drive folder.

Is there a command I should be using to update everything before running, or
maybe a better way to name the files that I should be using?


Thanks,
Nick M