How to deal with the logic on these?

[Seeker]

I want to auto save a file in 3 files name,
1st XXX.xls <- for daily activities, data refresh
2nd XXXbackup.xls <- backup 1 st file just in case it gets corrupted
3rd TodayXXX.xls <- as history record
I used SaveAs to auto save these three files in the BeforeClose and it
works. The question is how to arrange the logic say 1 week later when I open
the 3rd file again, how to avoid the macro overwrite the 1st and 2nd files
when I finished and close the book?
Similary, I have another macro to add =today() on sht 1 cell A1, this date
is linked to other cells for function calculation. How do I avoid this cell
being written as “today ()†start from next day and onward?
Rgds

 

[Ronx]

You will probably get better answers in a newsgroup or forum that deals with
Excel than here in FrontPage.

--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.