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)
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

I figured it out. I now use:

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

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org


"Chaplain Doug" wrote:

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)
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

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

Chaplain Doug wrote:
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)

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chaplain Doug" wrote in message ...
I figured it out. I now use:

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

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org


"Chaplain Doug" wrote:

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)
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org