How to catch the workbook names...
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.
|