I have tried using the macro recorder to import a csv file into an Excel workbook. The csv file name does not
change, but the excel filename changes each day (it is saved with todays date at the end)
file02oct.xls, file03oct.xls, etc
Using the macro recorder, it imports succesfully on day one, but the next day,
as soon as the excel file is renamed, the macro fails. It cannot recognise the change in the excel file name.
Please can you help me fix the macro so it can hope with the change in the excel filename each day?
Workbooks.Open Filename:= _
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines