GetOpenFilename doesn't support multiple files. Ben's solution requires XP
or above. If you have 2000 or below, post back, I have an API solution.

--
HTH

Bob Phillips

"LJi" wrote in message
ups.com...
Hi List,

I am using OpenDialog box to let user open more than one Excel file at
the same time. How can I catch the file names user choosed?

I tried the function Application.GetOpenFilename("Excel Files (*.xls),
*.xls"). But first, it didn't open any file, and secondly, it only
allows user to choose one at a time.

Any help will be appreciated.