Call Excel from Automic One

[MW-1]

I have an Excel workbook with macros that fire upon opening.  I want this activity orchestrated from Automic One.  I have tried using a task to call a bat script and a vbs, without success.  Are there any examples out there, showing how this can be achieved.  Thanks in advance.

[Legacy User]

There are various issues that might come up if you try to do office automation on server systems. Microsoft has a knowledge base article on this:
https://support.microsoft.com/en-us/help/257757/considerations-for-server-side-automation-of-office

I ran into exactly those issues when I tried to automate Visio.

[Lucas_Amorim_8287]

HiMark West,

What happened when you say "no success"?

Do you have excel installed on the Agent's machine?

[MW-1]

Sorry for lack of update.  I have managed to get the orchestration working using VBScript.  The VBScript itself is located on the Agents machine.