Hi,
what about this kb:
(no consideration for canceling)

XL2000: How to Create a Macro That Opens Multiple Selected Files
http://support.microsoft.com/kb/213635/EN-US/

XL: How to Create a Macro That Opens Multiple Selected Files
http://support.microsoft.com/kb/141574/EN-US/

--
HTH

okaizawa

LJi wrote:
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.