Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.GetOpenFilename
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.GetOpenFilename | Excel Programming | |||
How do I set a default path when using Application.GetOpenFilename | Excel Programming | |||
How do I set a default path when using Application.GetOpenFilename | Excel Programming | |||
Application.GetOpenFilename | Excel Programming | |||
Application.GetOpenFileName | Excel Programming |