Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default 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
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
Application.GetOpenFilename Greg[_19_] Excel Programming 3 February 20th 05 01:55 AM
How do I set a default path when using Application.GetOpenFilename pkohler[_8_] Excel Programming 2 July 13th 04 10:12 PM
How do I set a default path when using Application.GetOpenFilename pkohler[_7_] Excel Programming 2 July 13th 04 07:17 PM
Application.GetOpenFilename Philipp Oberleitner[_2_] Excel Programming 2 July 9th 04 07:29 PM
Application.GetOpenFileName ptrowe Excel Programming 2 September 11th 03 12:54 PM


All times are GMT +1. The time now is 05:37 AM.

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"