Detect Workbook or Spreadsheet

R

Richard John

Dear friends,

I'm currently building an application that loads data sourced from Excel,
into an Access database. The Excel files are coming in both a multi-sheet
workbook as well as single Excel 4 worksheet files. I want to
programatically detect (via VBA) if it is a Workbook or a single Excel 4
worksheet. How can I do this? I haven't been able to find anything on the MS
site.

Thanks
 
Top