Hello,

I have referenced an Excel 2007 spreadsheet called Consolidated 2012-08-18 to 2012-08-24 V2 but I just realized that the name of the sheet I need to reference isn't always going to be the same. It will however start with Consolidated 201x-xx-x to 201x-x-x where the X's are the characters that will change based on the date of the week as well as it could have a version number at the end or it could be blank at the end.

Am I able to step into the macro and replace the characters that will change with wildcards? If so, could somebody give me a little explanation as to how? I do not fully understand writing macros, I usually just record them.

Thanks!