View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.lorena@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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(Befo=excelBook.Sheets(tab lename + 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!