Application.GetOpenFileName
 

I am using Application.GetOpenFileName to prompt a user to select a file
from a list of files. It works fine to select a type of file
such a *.txt.

What I would like to do is to narrow the selection further, e.g.

sample*.txt.

The filter in the Application.GetOpenFileName does not recognize
anything before the *. This example would still display all .txt
files.

Has anyone come up with a method to display only certain files of a
specific type?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Application.GetOpenFileName
 

When the Open Filename dialog box opens, type sample*.txt and click the OK
button.

Milind
"ptrowe" wrote in message
...
I am using Application.GetOpenFileName to prompt a user to select a file
from a list of files. It works fine to select a type of file
such a *.txt.

What I would like to do is to narrow the selection further, e.g.

sample*.txt.

The filter in the Application.GetOpenFileName does not recognize
anything before the *. This example would still display all .txt
files.

Has anyone come up with a method to display only certain files of a
specific type?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/2003

Application.GetOpenFileName
 

Hi,

Try the example given in the help
Application.GetOpenFilename("Text Files (*.txt), *.txt")

Regards,
SSR

"ptrowe" wrote in message
...
I am using Application.GetOpenFileName to prompt a user to select a file
from a list of files. It works fine to select a type of file
such a *.txt.

What I would like to do is to narrow the selection further, e.g.

sample*.txt.

The filter in the Application.GetOpenFileName does not recognize
anything before the *. This example would still display all .txt
files.

Has anyone come up with a method to display only certain files of a
specific type?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/