[RESOLVED] Get First Excel Worksheet Name Re-opened

original post here:
http://www.vbforums.com/showthread.php?t=581216

The DAO method that originally considered to be my resolution isn't working with excel 2007 workbooks. Anyone have any ideas on how I could get it to work with those or an alternate route?

Error:
External table is not in the expected format.

Resolved again... using a 3 party dll to get it done.

Which API are you using?

Infragistics 9 CLR 3.5