Forum Discussion
Can I control what is displayed in a FileDialog
Hello MrCharlesJenkins
Thank you so much for your reply. I kinda had that but I wanted to check with the experts to verify.
What I ended up doing is:
A) Create a folder.
B) Check for any workbooks that match the date range and if the workbook matches the date range Copy it to the newly created folder.
C) Using Application.FileDialog(msoFileDialogFilePciker) I will display that newly created folder and the user now had all the workbooks that match.
It seemed a bit of an overkill to have to go through all that, but I guess since there is no native way, we have to get creative.
The only issue I have is that when I display the Application.FileDialog(msoFileDialogFilePciker) dialog with a predefined workbook name like when you use the .InitialFileName xxx the workbook name is selected and truncated like in the image attached:
There is a whole lot of a file name before the Ver.
Do you think I can use SendKeys to move the cursor to the left of the first character or is there a better way?
Thanks for your reply and confirmation, and happy Holidays to you and yours!
GiGi
Unfortunately, the FileDialog object in Excel doesn’t have a built-in way to filter files by date directly — it can only filter by file type or name patterns using the .Filters property. If you want to limit the files shown to those modified within a certain date range (like from 7 days ago until yesterday), you’d need to handle that part yourself after the user selects a folder or files. A common approach is to let the user pick a folder, then use VBA code to loop through the files in that folder (using Dir or the FileSystemObject) and check each file’s DateLastModified property. You can then build a custom list or display a message box showing only the files that fit your date criteria. In short, the FileDialog can’t filter by date before showing files, but you can easily apply your own date filter afterward in code.
------------------------------------
Don't forget to mark as solution if my answer suits you
Hello MrCharlesJenkins
Thank you so much for your reply. I kinda had that but I wanted to check with the experts to verify.
What I ended up doing is:
A) Create a folder.
B) Check for any workbooks that match the date range and if the workbook matches the date range Copy it to the newly created folder.
C) Using Application.FileDialog(msoFileDialogFilePciker) I will display that newly created folder and the user now had all the workbooks that match.
It seemed a bit of an overkill to have to go through all that, but I guess since there is no native way, we have to get creative.
The only issue I have is that when I display the Application.FileDialog(msoFileDialogFilePciker) dialog with a predefined workbook name like when you use the .InitialFileName xxx the workbook name is selected and truncated like in the image attached:
There is a whole lot of a file name before the Ver.
Do you think I can use SendKeys to move the cursor to the left of the first character or is there a better way?
Thanks for your reply and confirmation, and happy Holidays to you and yours!
GiGi