Using GetOpenFilename

C

Chaplain Doug

Excel 2007. How do I use the .GetOpenFilename method to open a selection
dialog that shows all possible Excel files (like *.xls, *.xlsx, *.xlb, etc.)?
Right now I use:

FName = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , Prompt,
, MultiFileSelect)
 
C

Chaplain Doug

I figured it out. I now use:

FName = Application.GetOpenFilename("Excel Files (*.xl*), *.xl*", , Prompt,
, MultiFileSelect)
 
A

Andy Pope

Hi,

The help file says.

To use multiple MS-DOS wildcard expressions for a single file filter
type, separate the wildcard expressions with semicolons; for example,
"Visual Basic Files (*.bas; *.txt),*.bas;*.txt".

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top