Question:
Can I run Microsoft Office applications like Excel or Word in batch, through Visual Basic, or other means with Control-M?

Applies to:
Control-M/Agent on Windows
 

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this environment.

All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation. They assume an interactive desktop and user profile, and do not provide the level of reentrancy or security that is necessary to meet the needs of server-side components that are designed to run unattended.

The Microsoft article https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2  describes the issue.

CONTROL-M doesn't support Microsoft Office applications running in batch mode.