Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. Microsoft Excel Chart

Microsoft Excel Chart

Scheduled Pinned Locked Moved Visual Basic
questioncom
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    Lost User
    wrote on last edited by
    #1

    How do I activate the OLE component Microsoft Excel Chart at runtime exactly like I have designed it and how do I put new data in to the chart at runtime?

    L 1 Reply Last reply
    0
    • L Lost User

      How do I activate the OLE component Microsoft Excel Chart at runtime exactly like I have designed it and how do I put new data in to the chart at runtime?

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Pleeeeeease can´t anyone help me with this, it´s breaking me... Men in long white coats will come and get me soon if I dont solve this problem. = (

      A 1 Reply Last reply
      0
      • L Lost User

        Pleeeeeease can´t anyone help me with this, it´s breaking me... Men in long white coats will come and get me soon if I dont solve this problem. = (

        A Offline
        A Offline
        afronaut
        wrote on last edited by
        #3

        It's tricky to make it seem as though *you* were the one who did it. Here's a starting point- you may already be past this: 1. In Excel, start a macro and then create the chart. 2. Examine the code in the macro generated VBA module. 3. Instantiate the Excel.Application, Workbook, Chart and create a chart programmatically using the macro code as your guide. It isn't difficult to do, but it will require that you users have Excel on their machines. Oh, and you can macro copy+paste operations too, in case you want to copy it to an OLE container control or something like that. I hope this puts you on a track... David *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups