PAX API - error when calling macro
Posted: Thu Jul 02, 2020 3:39 am
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
I have enabled in my code
However it still doesn't seem to work. Would really appreciate some help/guidance on this!
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 2071 times
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 2071 times