Filling excel file which has macro


#1

Hi There,
I have an excel file with more macro functionality with more work sheets. I want to add data into sheets in between say Row 10, Row 13 based on column header. can you please guide the best implementation approach in high level.
Thanks in advance

Sujatha


#2

Hi @sujatha_yuvaraj

Please refer to blogs which are posted for Excel automation.

You can use excel app activities if you file is .xls else use workbook activities for other files.

Execute Macro activity is available to run macro after data is updated on sheet.

Regards,
Ashish