| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file to Network Drive and prompt for name
Dim sFile As String
sFile$ = Application.GetSaveAsFilename() If sFile = False Then Exit Sub End If If InStr(1, sFile, ".xls") = 0 Then sFile = sFile & ".xls" End If ActiveWorkbook.SaveAs (sFile) --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
| My computer will not save to my network drive | Excel Discussion (Misc queries) | |||
| Excel 2k3: Workbook on network drive, when save creates new file | Excel Discussion (Misc queries) | |||
| why am I unable to save a Excel file on a network drive%3f | Excel Worksheet Functions | |||
| How to Save on a Network Drive using UNC? | Excel Programming | |||
![mudraker[_105_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
