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

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

Thanks JLGWhiz.......
I obtain the CurrFilePath from "ActiveWorkbook.Path" and then save my
created file to (CurrFilePath & "\RequiredSubDir\" &
CreatedFileName). As far as I can work out, that should satisfy the
detailed input that you describe. Any other suggestions?
Cheers
Dave