| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a default path name under Save As Dialog Box
Folks,
I am running a macro that should prompt the user to save the file under a default path name. I would like the macro to save the file in, for example, S:\Accounting\BSP 2006\File Name. Could you please suggest a solution? Thank you. Regards, Shams. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting a default path name under Save As Dialog Box
With Application.FileDialog(msoFileDialogSaveAs)
.InitialFileName = "S:\Accounting\BSP 2006\" .AllowMultiSelect = False If .Show = False Then Exit Sub ActiveWorkbook.SaveAs Filename:=.SelectedItems(1) End With Try that... Die_Another_Day Shams wrote: Folks, I am running a macro that should prompt the user to save the file under a default path name. I would like the macro to save the file in, for example, S:\Accounting\BSP 2006\File Name. Could you please suggest a solution? Thank you. Regards, Shams. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Default Save Path | Excel Programming | |||
| Setiiing up file name & path as a default setting on all sheets/ta | Excel Discussion (Misc queries) | |||
| change default file path in Save As dialog box | Excel Programming | |||
| GetOpenFilename Dialog default path | Excel Programming | |||
| Setting the default file name in the XLDialogSaveAs dialog box | Excel Programming | |||
Linear Mode
