run a vbscript and pass a parameter

[mstoler]

Hello,

I would like to call a vbscript at the end of my workflow and pass the parameter ExcelFileName which is a field in my workflow.  

Before I call the run I will do a Summarize so there is only a single record.  How can I pass the parameter to my vbscript when the parameter is a field in my workflow.

Thank You,

Michael

[T_Willins · Accepted solution]

Hi @mstoler,

Pass the parameter to an Excel file that is called from the VBA script.  Use a Block Until Done tool (parameter and VBA script call in a single workflow) or a use a Conditional Runner or a List Runner CReW macro (parameter and VBA script in separate workflows) to run the VBA script after the Excel file is updated with the parameter.