##Save to Unmapped Drive##

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi folks,

How do I go about saving the current worksheet to a server location if
a drive mapping is not present. The server location is not likely to change
so I just need a way to hardcode the server path into the SaveAs code.
Anybody Help?
 
so just do that <g>

ActiveWorkbook.Save "//server/folder/myname.xls"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving in VBA to a particular location 3
save and exit macro 8
unable to unmap network drive 3
Macro in excel to save to an unmapped drive ! 2
Save As 3
Saving workbook to multiple locations 1
Save ActiveWorkbook dilemma 3
How to unmap certain partitions? 8

Back
Top