The directory has to include the drive designation for the server. If you do
not specify the path\directory in the save or saveas statement, it will
default to the local directory. Or you can map to the server as your default
directory which will then automatically save everything to the server.
Computers are stupid, they have to be told what to do in intricate detail.

"AussieDave" wrote:

Not sure if anyone out there is familiar with eRooms (an online shared
server and communication tool ) but I'll try my question.....

The macro I've written performs correctly on my desktop and saves a
created file to an existing sub-directory of the current path.

However, when I load my spreadsheet to the eRoom (which also has the
sub-directory set up) and run the macro, instead of saving the created
file to the sub-directory in the eRoom, it writes the file to my local
C:\Documents and Settings\.....

How can I ensure that the file is saved to the sub-directory in eRoom?

Cheers, Dave