Activating a worksheet with a daily changing name, using a single macro

Hi all,

So I currently deal with reports that get generated daily. The names remain the same, except for the new date for each one. So, today's filename would be "DAILY REPORT 20101213.xls", for example.

What I'm trying to figure out is if it's possible to write something which will be able to call each day's format in the yyyymmdd format and then concatenate it with the rest of the file-name which is saved as a regular string. Or do something which would achieve a similar affect.

Any input would be gratefully received!

Thanks in advance.

I don't fully understand what you're trying to do, but:

Please Login or Register  to view this content.

Is that what you're looking for?