Cognos Analytics

 View Only
  • 1.  Excel Report - Create Macro Enabled Workbooks

    Posted Mon September 19, 2022 09:44 AM
    I have 2 related questions:

    1.) How do I create Macro enabled Workbooks from Cognos Analytics ?
    2.) How would I actually create macros  (What is the mechanism?) , so that when the Macro Enabled Excel workbook is created, the macros I want are there?


    ------------------------------
    David Lydon
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Excel Report - Create Macro Enabled Workbooks

    IBM Champion
    Posted Tue September 20, 2022 04:11 AM
    Hi David,

    I think it is not possible to create macro enabled workbooks from Cognos Analytics.

    Regarding your question #2, it is something you can find from Microsoft website:
    Quick start: Create a macro

    Note: you need to enable the Developer tab.

    Best regards,


    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 3.  RE: Excel Report - Create Macro Enabled Workbooks

    Posted Tue September 20, 2022 10:57 AM
    Hi Patrick,

    Thanks for taking time to respond.  That would be a shame if it were not possible.  I had my doubts, but still was holding out hope.   I'll open up an Enhancement Request if I don't hear anything else.  With respect to Question #2, I was referring to inside Cognos Analytics (Reports).  How inside a report could I create a macro for the Excel file that the report would generate?.  If there is no way to have Cognos create macro enabled workbooks, then there would seem to be no way inside Cognos to create the macros.​​​

    ------------------------------
    David Lydon
    ------------------------------