| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
##Save to Unmapped Drive##
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
##Save to Unmapped Drive##
so just do that <g
ActiveWorkbook.Save "//server/folder/myname.xls" -- Regards, Tom Ogilvy "Jimmy" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The SAVE AS button does not show save to G: drive | New Users to Excel | |||
| Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
| Macro in excel to save to an unmapped drive ! | Excel Discussion (Misc queries) | |||
| Why can't I save on CD in drive D | Excel Discussion (Misc queries) | |||
| How to Save on a Network Drive using UNC? | Excel Programming | |||
Linear Mode
