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?
Planning Analytics VBA Events
- 20 Ton Squirrel
- Posts: 71
- Joined: Tue Jul 14, 2020 9:53 pm
- OLAP Product: TM1
- Version: Planning Analytics with Watson
- Excel Version: Office 365
- Location: Houston, TX
Planning Analytics VBA Events
War teaches us geography, getting old teaches us biology.
-
- Regular Participant
- Posts: 197
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Planning Analytics VBA Events
https://ibm.github.io/paxapi/#useragentscreleasefull
Could you use the wait command in the link above?
Could you use the wait command in the link above?
- 20 Ton Squirrel
- Posts: 71
- Joined: Tue Jul 14, 2020 9:53 pm
- OLAP Product: TM1
- Version: Planning Analytics with Watson
- Excel Version: Office 365
- Location: Houston, TX
Re: Planning Analytics VBA Events
Brilliant, that is EXACTLY what I need. Thanks, Burnstripe
War teaches us geography, getting old teaches us biology.