Save with 2 names

T

tclark14

How would you write a macro that would automate saving a spreadsheet
file twice using two different names. File saveas FILENAME1, File save
as FILENAME2? I don't really want a backup file, I need an original
file that is saved, but I will allow others into the second file so the
original stays intact.

Thanks!
 
B

Bill Kuunders

Just an example....
This instruction can be in the this workbook code __before close__
ActiveWorkbook.Save
ActiveWorkbook.SaveCopyAs "c:\backup\curr,b4,roll.XLS"

the first line will just do a normal save
the second line does a save with the new name without changing the name of
the open file

But,,,,,,, if you want the original file without any changes then I suggets
that you take a copy before
anything else happens and store that somewhere save.
The automation will only take a copy of the changed file unless you take a
copy before opening the file.
 
Top