View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LJi LJi is offline
external usenet poster
 
Posts: 7
Default 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.