alienscript
09-09-2007, 04:05 AM
Dear VBA Excel expert,
I am hitting wall as a part of my office work data reports automation. I hope I could get some help from this great forum. The workbooks are stored in C:\WeeklyData\ in filename format as WEEKLY DATAFILE YYYY-MM-DD.xls Sometimes there are several different weekly workbooks in the folder. The file with the lastModified Date may not be the latest or most updated file because someone could have opened and saved an old file before the procedure is executed.
In my examples I used the method to open the most recent file which is by far I could achieve. I want the procedure to be able to open the workbook with the latest date as part of the date format in the filenames. I am desperate for some help and hope for some kind answers here. With great gratitude and Thousands of thanks.
I am using Xls 2003, Windows XP and attached the work examples
I am hitting wall as a part of my office work data reports automation. I hope I could get some help from this great forum. The workbooks are stored in C:\WeeklyData\ in filename format as WEEKLY DATAFILE YYYY-MM-DD.xls Sometimes there are several different weekly workbooks in the folder. The file with the lastModified Date may not be the latest or most updated file because someone could have opened and saved an old file before the procedure is executed.
In my examples I used the method to open the most recent file which is by far I could achieve. I want the procedure to be able to open the workbook with the latest date as part of the date format in the filenames. I am desperate for some help and hope for some kind answers here. With great gratitude and Thousands of thanks.
I am using Xls 2003, Windows XP and attached the work examples