Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I am using the following construct to select files......., which works great. xFile = Application.GetOpenFilename("ARTS_Daily (*.xls), *.xls", 1, "Choose File", "", False) I have a need to filter not just the file extension as in *.xls but also the filename eg ... ARTS*.xls, to give all xls files beginning with ARTS. Something like..... xFile = Application.GetOpenFilename("ARTS_Daily (ARTS*.xls), ARTS*.xls", 1, "Choose File", "", False) However this does not work as expected, with the dialog defaulting the filter to All files *.* Any ideas anyone on how best to achieve this? -- Cheers Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
Help, how do you open dialog box to filter a column | Excel Discussion (Misc queries) | |||
File Open Dialog | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming | |||
File open dialog | Excel Programming |