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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
sqlite-odbc write conflict 2
Need Help with Macro Security 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0
How to paste this down? 3
Mail Merge Directory Conditional Page Break 0
Need Help with a VBA subroutine 0

Top