Closing Macro with current date
===

I am using a macro to close several files and one of them uses a current date in the file name. I need the macro to click in the workbook and then close it and save it. I think I almost have it but I just can'tget the macro to click in the active workbook, which filename will change daily. This is what I have.

    Dim ClosePath As String
    Dim ClosePathDate As String
    
    ClosePath = "File_":
    ClosePathDate = ClosePath & Format(Date, "YYYYMMDD") & ".xlsx"
    
    Windows("ClosePathDate").Activate
    Sheets("Sheet1").Select
    Range("A1").Select
    ActiveWorkbook.Close SaveChanges:=True


I am not sure how to use " Windows("ClosePathDate") " I also tried Windows=ClosePathDate.Activate, no luck.

Please help.