Results 1 to 2 of 2

Thread: Excel automation- Chart object?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Dec 2003
    Location
    Baton Rouge, Louisiana.
    Posts
    109

    Question Excel automation- Chart object?

    Hii All,

    What i want to do is to generate Excel sheet and draw chart on sheet at run time using data from VB. My app. is developed in VB.

    Does anybody have done this? Any reference or example or web link? Please provide some input.

    I know how to create excel object from vb and use it's properties. But i have never done work realted to chart in Excel.

    Everything is welcome.

    Thanks,

    Himanshu Dave
    draw chart
    ~~~......Hope never dies. one has to work for it to make it reality.......~~~

  2. #2
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961
    Programmatically manipulating the Excel object is not well documented - esp. on the web. Very few examples. I had to buy a book to learn anything. I suggest you do the same:

    "Writing Excel Macros with VBA, Second Edition" by Ronan, an O'Reily book.

    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width