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