Looks like you figured it out, congrats and good luck!

--JP

On Sep 29, 4:08*pm, Noe wrote:
JP

Thank you so much for your help this is done, Thank you and have a great day.



"Noe" wrote:
Windows(" REPORT 09262009.xls").Activate *The formula you sent me was only
read from todays date and if i need to open that file 09262009 its give in me
an error.

"Noe" wrote:

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.