Saving on the server
 

Ajit,

Not a problem at all! What you're looking for is the so-called UNC address.
The format is
\\ServerName\FilderName1\...FolderNameN\Filename.e xt
so in your code you substitute the mapped string, e.g. "K:\Miscellaneous\My
Spreadsheet.xls", where K: is the mapping of, say, Folder "Shared" on server
ServerName, with
"\\ServerName\Shared\Miscellaneous\My Spreadsheet.xls"
If you're not sure about the server name, open your Windows Explorer and
start drilling down from My Network Places till you find your target folder.
When you get there, the UNC folder path will be available for you, ready to
copy, in the address box right below the toolbar.

HTH,
Nikos

"Ajit" wrote in message
...
Again it could be straight forward and just my ignorance!!!!

I have a template which will be accessed through intranet (working fine)
....i am trying to explore a possibility that would it be possible to write a
macro on some done/save button...that when hit it could save the template
(after working on it) back to some other server ... which the user will have
write permission but is not mapped.

Why i fear mapping is that everyone will be using a different letter to
Map it. And won't it be a problem coding it ?

Suggestions will be appreciated.

Saving on the server
 

Thanks! Nikos
It worked perfect.

Rgds
Ajit