How to deal with the logic on these?

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top