In a folder I have Excel files named with dates like:
These files have a Workbook_Open() procedure to do some task and save itself automatically when the workbook is opened.
I need a vb script that'll be run daily to:
1. figure out the file name of yesterday's file.
2. save that file as myfilename_<today's date>.xls (This shouldn't be a problem even if the original file is opened/being viewed by another user, I think?)
3. open it - so the vba code I wrote will do the updates and save itself.
I need to finish this quickly but unfortunately I am new to vb script. Please help.