Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home



How to use multiselect in GetOpenFilename

Posted by Dannon on June 12, 2000 11:49 AM
Hi,

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)

Any hints?

Thanks,
Dannon


Check out our Excel VBA Resources

Re: How to use multiselect in GetOpenFilename

Posted by Dannon on June 13, 0100 5:07 AM
Thanks Ryan!!

That was exactly what I needed!! You're a life-saver!

Dannon


Re: How to use multiselect in GetOpenFilename

Posted by Ryan on June 12, 0100 5:13 PM
Dannon,

Here is the proper syntax:

fname = Application.GetOpenFilename(MultiSelect:=True)

Good Luck
Ryan




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.