Macro Code to Open file with dynamic name (and possibly re-save with different name)

I am trying to include in my macro a line of code to open files that I save down daily into a folder. The issue is that everyday they have the same static name, but then have DDMonYYYY-# at the end. Is there a way to make the code dynamic enough to find and open these folders? I would only need for the current day so maybe the today() function can be leveraged on the main sheet I have open to run the macro?

For Example: the Files are saved to C:\Documents\ with the below names

ACCOUNTNUM0 - Account Summary Extract - XXXXXXX - 24Dec2013-0.xls
ACCOUNTNUM1 - Account Summary Extract - XXXXXXX - 24Dec2013-1.xls
ACCOUNTNUM2 - Account Summary Extract - XXXXXXX - 24Dec2013-2.xls

Or is there another solution to open these and re-save without the date at the end?

Try:

Please Login or Register  to view this content.

This is great, thank you. Is there anyway to make the 0 reference a user inputted cell in another open workbook? i.e. the user types in -2 in workbook "Book 1" Sheet1 to have the current date minus 2 days?

This uses A1 as the user inputted range value.

Please Login or Register  to view this content.

again worked great, thanks. One last part - the reports are downloaded automatically to a folder "yyyymmdd" with a -1 date. My macro opens each file then copies certain data. Is there anyway to code this folder dynamically into the file path? So for today the files created a folder 20131225

an example file path C:\Documents\"This is where i would need the T-1 date folder"\ACCOUNTNUM0 - Account Summary Extract - XXXXXXX - " & Format(DateAdd("d", x, Date), "ddmmmyyyy") & "-0.xls

Maybe:

Please Login or Register  to view this content.

Take out the comment and try.

thanks for this!

Not a problem. You're welcome anytime.