LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default Open File Dialog Filter

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
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
Open Dialog Box to return Selected File Path and Not Open it. DMS Excel Programming 4 January 26th 10 12:46 PM
Help, how do you open dialog box to filter a column mulehead Excel Discussion (Misc queries) 4 May 21st 08 06:02 PM
File Open Dialog scantor145[_3_] Excel Programming 1 September 29th 04 12:04 AM
open file dialog-select file-import worksheet Divinedar Excel Programming 1 January 16th 04 07:13 PM
File open dialog Jan Kronsell[_2_] Excel Programming 1 September 5th 03 08:56 AM


All times are GMT +1. The time now is 01:53 AM.

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

About Us

"It's about Microsoft Excel"