Planning Analytics VBA Events

Post Reply
User avatar
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

Post by 20 Ton Squirrel »

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?
War teaches us geography, getting old teaches us biology.
burnstripe
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

Post by burnstripe »

https://ibm.github.io/paxapi/#useragentscreleasefull

Could you use the wait command in the link above?
User avatar
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

Post by 20 Ton Squirrel »

Brilliant, that is EXACTLY what I need. Thanks, Burnstripe :)
War teaches us geography, getting old teaches us biology.
Post Reply