Hi guys,

I have a macro that I run daily but I'm having some problems with one of the filenames that the macro refers to.

At the moment the macro looks like this:

Please Login or Register  to view this content.
The macro opens the Open File Dialog Box and the most recent Daily Report is then manually selected from the 'Reports' folder. The macro then alternates between the daily report and a seperate Trend Report file and copies a large amount of data into multiple sheets. Cell A1 contains the date so the macro then refers to the file "Daily Report 01 Jan 2013.xls", which I receive from another department. The file name doesn't always follow this naming convention though and might be named "Daily Report 1st January 2013.xls" or "January 1st Daily Report.xls" for example, which is causing me a problem with the macro.

I was wondering if there is a better way to define the daily report file.

I hope that all makes sense.

Thanks,

aldo23