Create an Excel chart from VB
[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?
Re:Create an Excel chart from VB
[Originally posted by Jim]
If you understand how object models work, then take a look at the excel model here
Using this and the object browser in vb, should give a pretty good head start.
Re:Re:Create an Excel chart from VB
[Originally posted by venu_93]
ÿ ÿ ÿ ÿ 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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL