Hi All,

I am trying to select an excel window that is presently open on my desktop. The Excel windows has a date (ddmmyy format) which is in the past the name of the file is MyExcel 140208_.xls. I wanted some help to select this window through a VBA code. I have tried coding

Windows("MyExcel " & AnyDate & "_.xls").Activate
    Sheets("MyExcel " & AnyDate & "_").Select

Anydate = Format(Date, "ddmmyy") < Date

this code is not able to activate the excel file.

please can somebody help me

Best Regards
Rohit Ghosh

Rohit

Assuming '< Date' in Anydate = Format(Date, "ddmmyy") < Date listed here, your code is fine. It should activate the workbook.

Can you also try

Workbooks("MyExcel " & AnyDate & "_.xls").Activate

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)