VBA to open file with partial name

[three482]

Hi everyone.

I’m trying to build a macro that will open the most recent file (“Daily Report.”)

The problem is - the file is always saved as “\DailyReport_yyyymmdd” followed by a series of numbers representing a time stamp when the file was created. Unfortunately, the report can be run at different times, so while the end of the file always starts with “Daily Report,” and I can add an input box to enter the date (since older files are periodically needed), I need something that will ignore the last six characters between the date and .CSV.

Thanks in advance!

 

[6StringJazzer]

You said "time stamp when the file was created" but you also said that you can enter any date you want, so it might not be the date the file was created. How are you defining "most recent file"? The one with the most recent yyyymmdd date, or the one that was created most recently (since you can create files with old dates)?

Also you saved the most important part as your very last word. Is the full file name format DailyReport_yyyymmdd.csv?

If you have any code right now it would be helpful to provide all of that so whatever we give you will be compatible. (Please use code tags when pasting code into a post.)