How to use Excel macros with parameters in Qt?



  • Hello boys and girls,

    I am traying to find out, how I can start a Excel macro with Qt and use parameters.

    At first I wrote a VBScript to open a Excel document and start this macro without parameters. Now I want a nice Qt application.

    Can someone tell me, how I can do some stuff with Qt:

    • update the sheets
    • save the Excel document
    • run a Excel macro with parameters
    • close Excle

    Here is my first try
    @
    QAxObject *excel = new QAxObject("Excel.Application", this);
    QAxObject *workbooks = excel->querySubObject("Workbooks");
    workbooks->dynamicCall("Open (const QString&)", m_excelFile);
    excel->dynamicCall("DisplayAlerts(Boolean)", true);
    //workbooks->dynamicCall("RefreshAll");
    excel->dynamicCall("Save");
    excel->dynamicCall("Run (const QString&)", "Screenshot");
    workbooks->dynamicCall("Close", true);
    excel->dynamicCall("Quit", 0);
    excel->destroyed();
    @

    PS: Thank you for your time and help. I am from Germany and that is the reason form my great english skills :)


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.