Excel Macro Activate another open book based on partial name

[NormChart55]

Hello,

I am wanting to use a macro to check data from another open workbook. The problem is that the workbook name will always change and have a new date. It will always start with 'Import' but daily would adjust (example: 'Import 10.23.23'). How can I adjust this to only look for 'Import" and exclude the date so that each day's file can be used? Below is example currently, but we have to manually save the file to remove the date. Thanks for any help on this.

Windows("Import.xlsx").Activate

Range("A1:AB1").Select

With Selection

 

[mumps]

Place this macro in your first workbook and make sure that both workbooks are the only open workbooks. The variable 'WB2' will give you the name of the other workbook.

Sub test()
    Dim WB As Workbook, wbName As String
    For Each WB In Workbooks
        If WB.Name <> ThisWorkbook.Name Then
            WB2 = WB.Name
        End If
    Next WB
End Sub

 

[NormChart55]

Thank you for that solution. We tend to have a lot of files open during this process so closing and reopening would really add the same time back when are trying to save during this. Is there a way to possibly include the date in the windows activate portion and have that change based on the current date?

 Windows("Import & TODAYS DATE FORMATTED 10.23.23.xlsx").Activate

Range("A1:AB1").Select

With Selection

 

[mumps]

Is this what you are looking for?

Windows("Import" & Format(Date, "mm.dd.yy") & ".xlsx").Activate

 

[NormChart55]

thank you for all the help! very much appreciated