All,

I have a file that is currently titled: May Scrap Net of Reserve with scrap codes.xls

I have a Macro that activates this file and applies various sorting and filtering. How would I define the "May" portion of that file name so as to allow it to update as each month, without users having to delve into the code? Below is the code I know how to define, with the "MonthName" portion that I need help with, highlited.

[CODE]
Filename = MonthName & "Scrap Net of Reserve with scrap codes" & ".xls"
Filename.Activate
[CODE]

Thanks.