Hi all,

I'm pretty new to Excel and VBA...hope somebody can help me with this:

I have built a workbook calculator to manage and sort data that comes in a weekly Excel file. As it is now, I have to copy and paste the data in the worksheet that I need to my workbook calculator and would like to automate the process with a macro. The problem I'm having is that the filename changes with the week that it comes in. For example...this week the file would be named "Weekly Data 4-06-2012" and next week the file would be named "Weekly Data 4-13-2012".

Is there a way to have the macro identify just the first couple of words in the file name and recognize that as the file that it needs?

Thanks so much for any help!!

Ben