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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
VBA Macro Training in Chennai 0
Detecting an orphaned Excel.Application 1
Run code from another workbook 7
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11
vba code does not run 3
How to see if the opened excel workbook is embeded in other office 0
Select Previously Selected worksheet (and/or select previouslyselected workbook) 5

Top