Create an Excel chart from VB

[anonymous]

[Originally posted by Ric]

Hello all, my VB program extracts data from a SQL Server database.ÿ I now want to take this data and use it to create a chart in Excel and then save the file to make it available to all the users.ÿ

Can someone show me how to do it or point me to another resource (ie book, website, etc) that will show me how?

Thanks everyone!

Ric

[anonymous]

[Originally posted by Jim]

If you understand how object models work, then take a look at the excel model here
http://www.microsoft.com/officedev/articles/omg
Using this and the object browser in vb, should give a pretty good head start.

[anonymous]

[Originally posted by venu_93]

Hi ..

ÿ ÿ ÿ ÿ Create an Excel Object using create object method and assign ur recordset rows to each cell of Excel .

There is a code in VBcode.com or Freevbcode.com about this .

Just search for Listview to excel ..

use that code

VENU