Opening File with dated name each day?

[Tyler_Durden]

I would like to open a certain file everyday. However each day this file is created and named with the date, for example Production_FixYYYYMMDD.csv, in VBA how do I accomplish this? The alternative I could think of is to create a .bat file to copy that file over to a separate directory and rename it Production_Fix.csv and just use that, but if that batch file fails to run that would cause issues. Thanks for your help!

[DonkeyOte]

You can use Date in VBA, eg

Please Login or Register  to view this content.

[Tyler_Durden]

Thank you... How would I code that to open the file and copy it to my other spreadsheet? This is what I recorded... Would I just put something like Workbooks.Open strCSV ?

Please Login or Register  to view this content.

[DonkeyOte]

If in doubt, test

[Tyler_Durden]

got it thanks