Excel 2007 : date range needed

**amandeepsharma89** · 07-17-2012, 11:34 AM

I have the following code

Please Login or Register  to view this content.

This code opens fdgforecast excel file and loads the data into my sheet. I want to incorporate date in the filename too e.g. fdgforecast071712, fdgforecast071812 and so on.

Now, I have a sheet named ForecastFDG in the same excel file, there is a date field in A14 of this sheet. If the date in A14 is 07/17/2012 it should open fdgforecast071712, if it is 07/18/2012 it should open fdgforecast071812.
Can you please help me out to incorporate this.

The button is not in ForecastFDG sheet it is in third sheet named Actual.

Waiting for expert help.

Amandeep