How to read an.xlsm (Macro File)
Question:
Is it possible to use xlsm files in process studio?
Solution:
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
For example:
Set objExcel=CreateObject("Excel.Application")
objExcel.Application.Run"'D:\Input\MacroSalesOutput.xlsm'!Module 1. Macro1 "
ObjExcel.Exit