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

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.



"Seeker" <(E-Mail Removed)> wrote in message
news:C195AAE6-0E16-4F93-9BF7-(E-Mail Removed)...
> 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
>