MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to use multiselect in GetOpenFilename

Posted 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)

Any hints?


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

Thanks Ryan!!

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


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


Here is the proper syntax:

fname = Application.GetOpenFilename(MultiSelect:=True)

Good Luck