ExcelBanter - Prompting 'Save As' in an Excel Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Prompting 'Save As' in an Excel Macro (https://www.excelbanter.com/excel-programming/318168-prompting-save-excel-macro.html)

Glenn Gooding

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?

Frank Kabel

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?

All times are GMT +1. The time now is 08:02 AM.