Supported macros

Microsoft® Office Excel macros are not created using Infor BI Q&A, but you can still create separate custom modules and attach them to the macro as a new step.

Q&A supports only these macros:

  • Run a specified Internal Definition:
    • Run Detail Report Formula.
    • Run Summary Report.
    • Run Data Send.
  • Recalculate:
    • Recalculate Range.
    • Recalculate Worksheet.
    • Recalculate Workbook.
  • Insert a formula:
    • Insert a specific internal formula.
    • Insert Summary Link formula.
    • Insert Summary Report formula.
    • Insert Detailed Report formula.
  • Log on/log off the Infor BI Q&A server.