Reading an.xlsm (Macro File)

Get Help & Discuss
,
1

Hi! All

Is it possible to use xlsm files in process studio?

2

Hi!

Using an Execute VB Script plugin from Process Studio, we can execute an Xlsm file.

For example:
Set objExcel=CreateObject(“Excel.Application”)

objExcel.Application.Run"‘D:\Input\MacroSalesOutput.xlsm’!Module 1. Macro1 "

ObjExcel.Exit