Accessing sub-directories in eRoom

[AussieDave]

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

 

[JLGWhiz]

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]

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

 

[JLGWhiz]

Depends on what the ActiveWorkbook.Path is. The server has its own Drive
designation which must be included as part of the path when you save the file.
If you ActiveWorkbook.Path is returning C:\ as the Drive, then it will save
to your local default drive. You need to be sure that the drive designation
in the path is for the server. Otherwise, it will not save to the server.

 

[AussieDave]

Just checked it out - yep, the ActiveWorkbook.Path returns C:
\Documents and Settings\etc..... so the created file is obviously
being written to a subdirectory on this path.
The problem is that I cannot see any way of finding out the drive for
the eRoom server - it's maintained by a third party.
Guess I'll just resort to a work-around with the user working from his
local machine and emailing the ouput to me.
Anyway, thanks for all your help.
Dave