Q. Can I save 2 copies at the once?

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
 
N

NickHK

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
 
Top