Populating Excel Ole With ADO Recordset

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?
tgogliaAsked:
Who is Participating?
 
altenaConnect With a Mentor Commented:
A nice alternative is to create a huge string
using "vbTab" (to separate columns) and "vbCRLF"
to go to the next row.

Then you only have to call a "paste" method in excel
and all of the data will be put in as once.

This is MUCH faster than looping aver the recordset
and putting in the values one by one.

Good Luck.
0
 
T38JetCommented:
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.

0
 
tgogliaAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.