Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default GetopenFilename & Files with special characteristics

Hi Ivan,

Thanks for your help. It works fine.

Greetings from Germany
Daniel
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
any special trick to opening up corrupt XLS files Hillary Excel Discussion (Misc queries) 3 November 26th 09 06:35 PM
Spreadsheet says CorruptedCompressedFile characteristics SarahLawrence Excel Discussion (Misc queries) 0 February 12th 07 09:01 AM
GetOpenFilename - How can you filter files starting with a letter... rede96[_2_] Excel Programming 10 April 22nd 04 01:04 PM
Directory "Locked" when selecting multiple files using GetOpenFilename esbey Excel Programming 1 March 4th 04 04:29 AM
Acquiring filenames for multiple files with GetOpenFilename John Excel Programming 1 December 17th 03 06:51 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"