Q. Can I save 2 copies at the once?

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

I'm working on a spreadsheet for which I'd like to save a copy in the
normal way, when I click "Save", PLUS, I'd like to save an extra copy
in a folder that's 'out of the way', at the same exact time.

Is there a way to do this?
Can anyone point me to a site/tutorial, if it's too involved?


Please respond here.
Thanks,
George
 
George,
The Workbook_BeforeSave event will be fired when the user tries to save the
WB.
Here you place code like:

ThisWorkBook.Save 'Save
original as is
ThisWorkBook.SaveAs "PathToOutOfTheWay" 'Save your extra copy

NickHk
 
You must log in or register to reply here.

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

Save data from Notebook: copying to the USB stick using Linux and the command line 0
Copying a Picture From Cell Comment 0
copy and save as csv 4
Modify Ron de Bruin Code; Save Specific Files to Specific Folders 1
Park and Ride in to Central London? 2
Copying Excel table to Word, with Formatting 2
Lose macros before saving 4
Command Button to export a worksheet as a .csv file 1

Back
Top