Results 1 to 6 of 6

Thread: MSGraph Chart

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: MSGraph Chart

    I would like to declear a MSGraph chart using its object name
    Dim OLE1 As ???????

    but not like that

    Dim OLE1 As Object

    i.e a pre-defiend decleration....

    What is the name of its Object or reference.....

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Hammbakka

    I can't answer the question. I tried playing around with Access graphs and found them clunky, a bit crude and difficult to manipulate programmatically (as you are).

    As such - I do all my graphs in Excel via automation.

    See how you get on. If you get no joy then I am more than happy to post my Excel code.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you very much for you nice answer, till I find a soultion (not sure), would you please send me such example.

    Thank you again

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Hammbakka

    Well - looking at the code (which I haven't done for a while) it looks like it really could be tidied up quite a bit. One of those things - I was struggling with getting it to work at all when I wrote it and never got round to tidying it up. Once it is working there is little incentive to revisit....

    Anyway - not model code but hopefully it should illustrate many of the objects you can use
    Attached Files Attached Files
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Hello pootle flump,
    thank you so much for the example, I'll have a look, hope not so hard.....

  6. #6
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Dim OLE1 As Graph.Chart

    Make sure that msgraph is included in your references. You can also use the object browser and graph library for more information.

Posting Permissions

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