How to select workbook with partial name "Book*"

[crystalneedshelpplzthnx]

https://www.mrexcel.com/forum/excel...pen-workbook-using-partial-name-wildcard.html

I am not comprehending how to add the fuzzy criteria to my code. Any help would be greatly appreciated.

Windows("Book1").Activate    ActiveWorkbook.SaveAs Filename:= _
    "Daily Performance Report " & Format(Now, "m.d.yy") & " Mass-Tier.xlsb" _
        , FileFormat:=xlExcel12, CreateBackup:=True

~Crystal

 

[ranman256]

you cant on SAVEAS, but you can open by setting wildcards in the filename

Filename: = "I:\users\abc\*book*"

 

[crystalneedshelpplzthnx]

Thank you for your response. I need the "activate" command updated. How do I utilize a wildcard there?

Windows("Book*").Activate

does not work