Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding line chart w/ 2nd axis to stacked bar chart | Charts and Charting in Excel | |||
worsheet | Excel Discussion (Misc queries) | |||
Worsheet and workbook | New Users to Excel | |||
Formula for Worsheet Name | Excel Discussion (Misc queries) | |||
secure your worsheet using vba | Excel Programming |