I have a project to manipulate Excel in VB.

I can open and read basic column info into VB arrays but there is a lot more to the RANGE object etc (from looking in the object browser)

anyone know where there is some documentation or tips web pages on reading excel data in VB??

I'm after getting details like:

Sheet count
First Row in row count (the row count figure starts at the first row with data, so if only row 23 - 25 have data, return of rowcount is 3)

First Col in col count (same as above)
data type in cell

just for starters anyway