Close file with variable date

[kanelones]

Hi Friends!

Here I am with a new question.

I Have a file named "OP_DD" , where DD is any past date. ( yesterday or several past days )

Need to close the file via macro.

I tried this..

Windows("op_" & Format(Now(), "DD-1") & ".xls").Activate
ActiveWindow.Close

But doesn't work like i expected , if i put "MM " for month instead ,works perfectly with a file named "op01" for january for example, (but not the first of the new month, but that is another tale..)

I 'll appreciate any help..

Tks!

 

[Jonmo1]

You should subtract the 1 from NOW(), not within the format...

Windows("op_" & Format(Now()-1, "DD") & ".xls").Activate

 

[kanelones]

Worked fine!!

Tks!