<div>
that's several questions....<br />
<br />
' Here's how you plug in the ADO recordset value<br />
objExcel.Application.Activ<wbr />eWorkbook.<wbr />Worksheets<wbr />(&quot;Sheet1&quot;)<wbr />.Rows(1).C<wbr />ells(1).Va<wbr />lue = rstRecords.Fields(&quot;Field1&quot;<wbr />).Value<br />
<br />
If your chart is based on a pivot table which gets its data from &quot;Sheet1&quot;, it will automatically appear in the chart.<br />
<br />

</div>


that's several questions....

' Here's how you plug in the ADO recordset value
objExcel.Application.ActiveWorkbook.Worksheets("Sheet1").Rows(1).Cells(1).Value = rstRecords.Fields("Field1").Value

If your chart is based on a pivot table which gets its data from "Sheet1", it will automatically appear in the chart.



<div>
Thanks for your help. Your code proved that I had the right idea, the problem was that I thought that when I created the OLE object, I assumed that the appropriate code libraries would automatically be added to the project. An incorrect assumption.<br />
tgoglia<br />

</div>


Thanks for your help. Your code proved that I had the right idea, the problem was that I thought that when I created the OLE object, I assumed that the appropriate code libraries would automatically be added to the project. An incorrect assumption.
tgoglia


<div>
<div class="content wysiwyg-content">
I have opened an excel worksheet object in my VB application and am attempting to populate it from an ADO recordset, and allow the user to print out the results. What is the method to import the data into the excel chart? When I run the application, all of the usual Excel menu items are there excepr for the File menu, which includes the Print command. How do I allow the user to print the date in the chart after they have formatted it?
</div>
</div>


I have opened an excel worksheet object in my VB application and am attempting to populate it from an ADO recordset, and allow the user to print out the results. What is the method to import the data into the excel chart? When I run the application, all of the usual Excel menu items are there excepr for the File menu, which includes the Print command. How do I allow the user to print the date in the chart after they have formatted it?

Populating Excel Ole With ADO Recordset

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.