Using GetOpenFilename

[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)

 

[Chaplain Doug]

I figured it out. I now use:

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

 

[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

 

[Ron de Bruin]

For a GetSaveAsFileName example for 2007 see example 2 on this page
http://www.rondebruin.nl/saveas.htm