Adding a Chart or Worsheet??? with VB.NET

Hi:
I have this problem, I have to insert first a chart, after a worksheet
to an excel file with VB.NET.

I'get an error in line 3 (below) "not found public member 'Cells' in
type 'Chart'"

How Can I define in line (1) the type of worksheets???

1 >excelBook.Sheets.Add(Before:=excelBook.Sheets(tablename + 1))
2 >For Each dcColumn In dstDataset.Tables(tablename).Columns
3 > excelApp.ActiveSheet.Cells(1, x) = dcColumn.ColumnName
4 > x += 1
5 > Next


thanks in advance!

Charts.Add

Worksheets.Add

--
Regards,
Tom Ogilvy

<paul.lorena@gmail.com> wrote in message
news:1107797155.764567.230960@z14g2000cwz.googlegroups.com...
> Hi:
> I have this problem, I have to insert first a chart, after a worksheet
> to an excel file with VB.NET.
>
> I'get an error in line 3 (below) "not found public member 'Cells' in
> type 'Chart'"
>
> How Can I define in line (1) the type of worksheets???
>
> 1 >excelBook.Sheets.Add(Before:=excelBook.Sheets(tablename + 1))
> 2 >For Each dcColumn In dstDataset.Tables(tablename).Columns
> 3 > excelApp.ActiveSheet.Cells(1, x) = dcColumn.ColumnName
> 4 > x += 1
> 5 > Next
>
>
> thanks in advance!
>