Question Getting the cell below the current one (excel)

[BloodyD]

Hey,
I currently got an assignment (well more like a request from my dad, but it's for company use so.)
He asked if I could make a program that retreives certain values from (different) sheets in one workbook, and export it to another one, eventually automaticly creating a graph with the data.

Now, I just started, was a while, worked in VB6 on school, but now trying to do it in VB.net .
I do the excel handling trough

Imports Excel = Microsoft.Office.Interop.Excel

, so no OleDb stuff, which I'm not known with.

I'm currently trying to make a user selection to specify if the value that should be looked for is right from, or below the cell that contains the f.e. 'Total numbers' field.
I first search for the 'Total numbers' using a .Cell.Find() function, and am wondering how to specify it.


Is there a way to do this ?

xlWorksheet.ActiveCell.Offset(0, 1).Select

doesn't work, throws :

Public member 'ActiveCell' on type 'Worksheet' not found.

And can I open an existing file, and create a new excel file at the same time ?
I mean reading the data out, and directly pasting it in the new file?

And, temporary last, but certainly not least, VERY important actually, is how to open a sheet within a workbook without knowing the name.
I tried :

 xlWorkSheet = xlWorkBook.Worksheets(0)

but sadly it doesn't work, throws :

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

Any other options ?

If anything is unclear, please ask.
If I posted in the wrong section, sorry but I couldn't really figure out what should be where so I tought this is the most corresponding one.

Regards

Daneo