ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File open dialog (https://www.excelbanter.com/excel-programming/276148-file-open-dialog.html)

Jan Kronsell[_2_]

File open dialog
 
Hi NG

I would like to display the file open dialog in a certain folder and with
only a specific filetype (CSV) show.

This will do the first part

ChDir "c:\Burn"
Application.Dialogs(xlDialogOpen).Show

but how do I select a specific filetype only.

Jan



Jan Kronsell[_2_]

File open dialog
 
I forgot: I would also like to check for any files in the folder before
displaying the file open dialog. If no files are found it should not show
the dialog, but a msgbox.

jan




All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com