Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  PAfE API with VBA with .xll addin

    Posted Mon May 15, 2023 06:14 PM

    In the current version for PAx, 2.0.84 - does the Cognos Office Automation Object still work ? ie: https://ibm.github.io/paxapi/#set-up



    ------------------------------
    Yeon Yi
    ------------------------------


  • 2.  RE: PAfE API with VBA with .xll addin

    Posted Tue May 16, 2023 12:41 AM

    Hi Yeon,

    PAfE API is definitely still working. We use this frequently.

    What is it your are trying to do, maybe there is something specific that is not working the way you expect?



    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------



  • 3.  RE: PAfE API with VBA with .xll addin

    Posted Tue May 16, 2023 02:38 PM

    good opportunity to remind that the automation object progID is now variable to support various interoperability compatibility scenarios with co-running Cognos for Microsoft Office and Planning Analytics for Excel

    if you're seeing a failure in getting the automation object, please check out

    https://ibm.github.io/paxapi/#necessary-ibm-cognos-automation-api-references



    ------------------------------
    Ted Phillips
    IBM
    ------------------------------