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.
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.
