| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompting 'Save As' in an Excel Macro
I need to set up a macro that Prints & Saves a spreadsheet.
The print part is OK, but I need to be able to have 'Save As' pop up on running the macro. Any clues please? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prompting 'Save As' in an Excel Macro
Hi
have a look at the GetSaveAsFilename Method in the VBA help "Glenn Gooding" wrote: I need to set up a macro that Prints & Saves a spreadsheet. The print part is OK, but I need to be able to have 'Save As' pop up on running the macro. Any clues please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop prompting for save the changes in Excel | Excel Discussion (Misc queries) | |||
| Excel Macro Save CSV Cell without Prompting | Excel Discussion (Misc queries) | |||
| Save CSV File without prompting | Excel Programming | |||
| Save file without prompting | Excel Programming | |||
| Excel not prompting to save Add-ins | Excel Programming | |||
Linear Mode
