MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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

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

Thanks Ryan!!

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

Dannon

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

Dannon,

Here is the proper syntax:

fname = Application.GetOpenFilename(MultiSelect:=True)

Good Luck
Ryan