Can I use Excel VBA Dialog box to display files starting Day*.xml so that my user can choose file to open

[UDAEY]

In Excel, the following VBA code does not work properly.

dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls")

It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen also, but the Dialog box shows all files in the folder (including day*.xls).

I want to open Dialogbox so that my user can select file to open from the Day*.xls files in the folder.

Any suggestions will be highly appreciated.