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