Forum Discussion
GeorgieAnne
Nov 23, 2025Iron Contributor
Can I control what is displayed in a FileDialog
Hello Excelers,
Hope you are all doing well.
Is there an option to limit the files displayed when you use something like:
With Application.FileDialog(msoFileDialogFilePciker)
.InitialFileName = "Book1"
.InitialView = msoFileDialogViewDetails
.Filters.Add "Excel Files, *.xls*"
.Title = "Choose a File"
(A way to limit files with a date range of say 7 days ago till yesterday
.Show
End With
I want to limit the files displayed by a date of 7 days ago to yesterday. I know I can use the DateLastModified of a file but the question is how to incorporate this with the msoFileDialogFilePciker.
Thanks in Advance!
GiGi
No RepliesBe the first to reply