You are viewing limited content. For full access, please sign in.

Question

Question

Trigger macro in Excel using script in Workflow

asked on March 18, 2020

Hi, is it possible to trigger a macro to run in Excel using a script in Workflow? Thanks.

0 0

Replies

replied on March 18, 2020

I am not sure that I follow what you are trying to do, but Excel files lock when you open them, so only 1 user can have it open at a time.  Also, workflow is a service, so it has no desktop and cannot interact with the desktops of (or applications running by) other users.

That said, you can use ODBC to push data into an Excel file or you can use a Script activity and reference a DLL to interact with the file directly.  See Calling excel's vba subroutine from vb.net application for an example of using VB.net to execute vba in Excel.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.