Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
How to use multiselect in GetOpenFilenamePosted by Dannon on June 12, 2000 11:49 AM
I was wondering if anyone can show me an example
of how to use GetOpenFilename so that I can open
more than one file at a time.
I see in the help file that making multiSelect true
is how to make this work, but I can't figure out
how to do that.
Here's the syntax that I'm using that's not working:
fname = Application.GetOpenFilename (MultiSelect)
|Check out our Excel VBA Resources
Re: How to use multiselect in GetOpenFilenamePosted by Dannon on June 13, 0100 5:07 AM
That was exactly what I needed!! You're a life-saver!
Re: How to use multiselect in GetOpenFilenamePosted by Ryan on June 12, 0100 5:13 PM
Here is the proper syntax:
fname = Application.GetOpenFilename(MultiSelect:=True)
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.