Thread: GetOpenFileName
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Bloom Greg Bloom is offline
external usenet poster
 
Posts: 10
Default 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