PAX API - error when calling macro

[Crayola]

Hi all!

I am testing out the PAX APIs based on: https://ibm.github.io/paxapi/#logon

My intention is to schedule weekly refresh & auto email of TM1 reports to non-tm1 users with the following steps:

1. Log on
2. Refresh all data
3. Unlink
4. Save as
5. email

When I have excel open and run the macro manually the entire process works through to the emailing however when i try to run it outside of excel I get the following error

Screenshot_1.png (14.15 KiB) Viewed 2069 times

I have enabled in my code

Code: Select all

For ndx = 1 To objExcel.Application.COMAddIns.Count
      	WScript.echo objExcel.Application.COMAddIns(ndx).Description
Next

Screenshot_2.png (14.33 KiB) Viewed 2069 times

However it still doesn't seem to work. Would really appreciate some help/guidance on this!

[Paul Segal]

This looks like a Windows issue, rather than an api issue, see https://www.tm1forum.com/viewtopic.php?f=3&t=14157