IBM Business Analytics

 View Only
Expand all | Collapse all

Using Python script to run an IBM PAX Excel macro?

  • 1.  Using Python script to run an IBM PAX Excel macro?

    Posted Mon August 26, 2024 04:23 PM
    Hello
     
    I have a simple Excel macro that has the following 2 line of code:
     
    Reporting.Explorations.Create 
     
    Application.COMAddIns("CognosOffice12.Connect").Object.AutomationServer.Application("COR", "1.1").RefreshSheet
     
    The parameter values for the Create call have been omitted.
     
    I can run the macro within Excel, and it is ok.  But when I run it via a Python script, it did not work.  Error was Object required at the first line.
    Any idea how to resolve this error?
     
    Thanks  



    ------------------------------
    Quin Kan
    ------------------------------