HI,
I have an Excel file named Daily.xls (Excel 2007) in a directory c://Data
this file is being changed every day. I need that the file is saved once daily (when it is open first time on a day) with the current date (in the form year-month-day) added to the file name, i.e. Daily_year-month-day.xls
in the directory c://Data/Archive
The original file Daily.xls should stay in the original directory c://Data
and it should be possible to open it, change data in it and save it during the day, without making a copy Daily_year-month-day.xls every time it is open during the day.
What would be the easiest way to do this automatically.
Thanks for your help.
Filipana
Bookmarks