writing code to auto save a spreadsheet

S

sk

I want to write a code to automatically save an excel spreadsheet but stop
when it gets to the "filename". I want to enter the filename and then
proceed.
 
J

Jim Rech

Application.Dialogs(xlDialogSaveAs).Show

--
Jim Rech
Excel MVP
|I want to write a code to automatically save an excel spreadsheet but stop
| when it gets to the "filename". I want to enter the filename and then
| proceed.
 
Top