Do wildcards work when trying to open a file using VBA?

[Gundisalvus]

Hello, I have a macro that should run monthly on a file that has a specific title only changing dependind on the month, example: "M02 - Royalty" can I make it open using wildcards?
something like "M## - Royalty"?
sorry for such a basic question but its sensible data and I am scared I might do something to it unintentionally.

 

[Tupe77]

Wildcards requires using the dir command.

Dim wordapp: Set wordapp = CreateObject("word.Application")
    wordapp.Documents.Open ("C:\Monthly_Reports\Customer_02\" & Dir("C:\Monthly_Reports\Customer_02\My Customer Report*.docx"))
    wordapp.Visible = True

 

[Tupe77]

The example was how to use the dir -command, but here is another version that is for excel.

Workbooks.Open Filename:=("P:\Excel\" & Dir("P:\Excel\M* - Royalty.xlsm"))