Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetopenFilename & Files with special characteristics
Hi VBA-Professionals,
my Question: Is it possible to get only special files in the getopenfilename dialog. I mean: I want excel files which have the string "*test*.xls" in the filename. I know how to use the filter that I get only excel files but I want to extend the filter. Thanks for help which i hopefully get Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetopenFilename & Files with special characteristics
Hi
AFAIK this is not possible -- Regards Frank Kabel Frankfurt, Germany Daniel Debes wrote: Hi VBA-Professionals, my Question: Is it possible to get only special files in the getopenfilename dialog. I mean: I want excel files which have the string "*test*.xls" in the filename. I know how to use the filter that I get only excel files but I want to extend the filter. Thanks for help which i hopefully get Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetopenFilename & Files with special characteristics
Hi Daniel
Not with code but You can enter this in the Filename box *test* and press Enter -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi AFAIK this is not possible -- Regards Frank Kabel Frankfurt, Germany Daniel Debes wrote: Hi VBA-Professionals, my Question: Is it possible to get only special files in the getopenfilename dialog. I mean: I want excel files which have the string "*test*.xls" in the filename. I know how to use the filter that I get only excel files but I want to extend the filter. Thanks for help which i hopefully get Daniel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetopenFilename & Files with special characteristics
Hi Daniel
Have a look here on how to do this via code http://www.xcelfiles.com/comdlg.html (Daniel Debes) wrote in message . com... Hi VBA-Professionals, my Question: Is it possible to get only special files in the getopenfilename dialog. I mean: I want excel files which have the string "*test*.xls" in the filename. I know how to use the filter that I get only excel files but I want to extend the filter. Thanks for help which i hopefully get Daniel |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetopenFilename & Files with special characteristics
Hi Ivan,
Thanks for your help. It works fine. Greetings from Germany Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any special trick to opening up corrupt XLS files | Excel Discussion (Misc queries) | |||
Spreadsheet says CorruptedCompressedFile characteristics | Excel Discussion (Misc queries) | |||
GetOpenFilename - How can you filter files starting with a letter... | Excel Programming | |||
Directory "Locked" when selecting multiple files using GetOpenFilename | Excel Programming | |||
Acquiring filenames for multiple files with GetOpenFilename | Excel Programming |