Planning Analytics VBA Events
Posted: Tue Mar 29, 2022 4:50 pm
Is there a way to hook into events with the Planning Analytics VBA API?
I'm trying to automate some actions that should take place after a Quick Report is done updating or when something like a TM1ELLIST function updates on a specific worksheet. Nothing terribly complicated, honestly.
Would this be done by hooking into the Worksheet_Change or Worksheet_Calculate events? Or is there something in the Automation or Reporting object that I can test against?
I'm trying to automate some actions that should take place after a Quick Report is done updating or when something like a TM1ELLIST function updates on a specific worksheet. Nothing terribly complicated, honestly.
Would this be done by hooking into the Worksheet_Change or Worksheet_Calculate events? Or is there something in the Automation or Reporting object that I can test against?
