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