Could someone provide me with some code that will allow me to open a csv file with Excel 2010 where the date changes every day. The report name [today] is
Yesterdays report was FinanceReport_20130520_22174900_csv
Previous day was FinanceReport_20130517_22174700_csv
Each day I need to open the last working days file so today I need to open the file dated 20130521 but on a Monday I need to open the file from the Friday so this last Monday I needed to open the file with the date 20130517.
This is a tricky one so Thanks in advance.