Hi!

Does anyone have any experience with running VBA-macros from a TI-process using powershell-scripts?

I'm trying to run a set of macros in a Xlsm-file from a TI-process with  ExecuteCommand() with a set of parameters using a bat-file that starts a powershell-script that runs to Excel-macros.

I have added debugging in the ps1-script so I can see that it is running, but it doesn't initiate Excel and run the macros from the TI-process. (It works fine when I start the bat-file manually).

Code in TI-process:

Bat-file:

Powershell-script:

Btw. Excel is installed on the server.

I really appreciate any tips and suggestions.

Regards,

Willem

You have run it manually but did you run it under your account or the service account that TM1 is running under? It could just be a permissions issue sobfurstcstep woukd be logging in under the service account and trying it.

Does it create a new Excel instance?