ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GetOpenFilename (https://www.excelbanter.com/excel-programming/290738-getopenfilename.html)

Greg Bloom

GetOpenFilename
 
Is there a way to filter, let's say all the excel files that start with
"1*.xls"

Filt = "Excel Files (*.xls),1*.xls" - this does not work, it brings in
all files in the sub-directory.
FilterIndex = 1
Title = "Select Order to Open"

FileName = Application.GetOpenFilename(filefilter:=Filt,
FilterIndex:=FilterIndex, Title:=Title)

thanks
Greg





All times are GMT +1. The time now is 01:46 AM.

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