Forum Discussion

GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
Nov 23, 2025

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

Resources