Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all, we have some important news to share. Please follow the link here to find out more!

https://www.boards.ie/discussion/2058419143/important-news/p1?new=1

Drawing charts in excel and importing them to a Win32 C++ App

  • 31-03-2002 02:45AM
    #1
    viper_47_2
    Closed Accounts Posts: 5 ✭


    Urgently need to know if it is possible to draw a chart or graph from a Win32 App in Visual C++ using MS Excel ??

    Have scoured web and found nothing.

    Any help would be appreciated !!!

    Thanks.


Comments

  • #2
    Rev Hellfire
    Closed Accounts Posts: 7,346 ✭✭✭Rev Hellfire


    Not sure exactly what you want to do.
    But you can always use the Excel DOM to do it get a WorkSheetPtr and look for teh charts collection and add to that or enumerate it if you're trying to retrieve a chart

    to help you on your way

    #import "C:\Program Files\Microsoft Office\Office\mso9.dll" no_namespace
    #import "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\vbe6ext.olb" no_namespace
    #import "C:\Program Files\Microsoft Office\Office\excel9.olb" rename("DialogBox", "ExcelDialogBox") rename("RGB", "ExcelRGB") rename("DocumentProperties", "ExcelDocumentProperties") rename("ExitWindows", "ExcelExitWindows")

    You'd get more help on the programming board I'd suspect.


  • #3
    viper_47_2
    Closed Accounts Posts: 5 ✭viper_47_2


    Thanks Rev Hellfire,

    So this will let me retrieve a chart from excel and display it in a Win32 App using Visual C++ ??

    If so, then it sounds like it is exactly what i need.


Advertisement