by nilesh@winayak.com Thu Apr 15, 2021 1:18 pm
hello ,
the is quite easy you just to follow few things ,first you cant either record or write macro in excel file
and make that file macro enable which will create .xlsm file for you ,
now as you know there are no specific steps or dedicated activity is present in kofax rpa to execute the macro you have to do it with help of vb script
so after creating macro you second step is to make vb script file which make sure that your macro will run
this a sample code for running a alreay present macro in an excel
set objExcel=CreateObject("Excel.Application")
objExcel.Application.Run"'C:\Users\Nilesh\Desktop\macrofile.xlsm'!Module1.macro1" //excel filename followed by the macro name
objExcel.DisplayAlerts=False
objExcel.save //this will save the changes which macro has made into the data
objExcel.Application.quit//closing the excel file
once your done with this ,the very last step is to excute that vb script.
so the last step is to command line step and excute the vb.script file
try this and let me know if it useful or not