| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pausing a "save as" macro
It sounds like you simply want to show the SaveAs dialog box... you can do as
follows: Sub Example() Dim oDialogSaveAs As FileDialog Set oDialogSaveAs = Application.FileDialog(msoFileDialogSaveAs) With oDialogSaveAs .InitialFileName = Format(Date, "ddmmmyyyy") .Show End With End Sub If that's not it. Post the code you have. -- Best regards Robert, Excel MVP Author of RibbonX: Customizing the Office 2007 Ribbon: Find me at http://www.msofficegurus.com - be part of it! FORUM: http://www.msofficegurus.com/forum/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro in WB assigned to toolbar, after "save as" points to differn | Excel Discussion (Misc queries) | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Macro to create "path" for save | Excel Discussion (Misc queries) | |||
Threaded Mode
