getting multiple filenames

[Ryan H.]

Hello,

Is there a way to get the filenames for multiple files in an open dialog
box?

I know this works for only choosing one file and then it returns the path to
that filename.. but I want to be able to choose multiple files:

FileToOpen = Application.GetOpenFilename(Title:="Open file to process",
FileFilter:="Excel Files *.xls (*.xls),")

I want something like:

FilesToOpen = Application.GetOpenFilenames(Title:="Open files to process",
FileFilter:="Excel Files *.xls (*.xls),")


Thank you

 

[Ryan H.]

sorry.. wrong forum...

but I found my answer.. MultiSelect:=true

 

[Frank Kabel]

Hi
have a look at the GetOpenFilename-Method in the VBA help and use the
MultiSelect option for this method