LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding line chart w/ 2nd axis to stacked bar chart Greg Yedinak Charts and Charting in Excel 1 January 12th 09 10:51 PM
worsheet evelyne Excel Discussion (Misc queries) 2 April 13th 07 11:29 PM
Worsheet and workbook tiler New Users to Excel 1 April 19th 06 01:22 PM
Formula for Worsheet Name Paul Sheppard Excel Discussion (Misc queries) 2 December 19th 05 04:42 PM
secure your worsheet using vba solo_razor[_34_] Excel Programming 1 November 17th 03 02:03 PM


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"