Using GetOpenFilename
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 |
Using GetOpenFilename
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 |
Using GetOpenFilename
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) |
Using GetOpenFilename
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 |
All times are GMT +1. The time now is 05:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com