Hello,

I have a macro that when it is hard coded with the file name, works fine. But when I put in a variable it fails. Any thoughts?

Code that works:

Please Login or Register  to view this content.
But when I change it to the following, it fails.
Please Login or Register  to view this content.
I want to keep it soft coded so that I don't have to remember to change the date come 1/1/15.

Thank You.