Create an Excel chart from VB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Create an Excel chart from VB

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    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?

    Thanks everyone!

    Ric

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    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
    http://www.microsoft.com/officedev/articles/omg
    Using this and the object browser in vb, should give a pretty good head start.

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Create an Excel chart from VB

    [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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center