Save with 2 names

[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!

[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.

--
Greetings from New Zealand
Bill K


"tclark14" <[email protected]> wrote in
message news:[email protected]...
>
> 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!
>
>
> --
> tclark14
> ------------------------------------------------------------------------
> tclark14's Profile:
> http://www.excelforum.com/member.php...o&userid=11502
> View this thread: http://www.excelforum.com/showthread...hreadid=529008
>