How to execute macro of other workbook in the present workbook, during automation

[srikanth999 (srikanth)]

Hi,

I want to execute macro which is other workbook(excel), In the current workbook. I wrote a macro for deleting rows from 1 to 11. Here is the code

Sub Macro1()
Rows(“1:11”).EntireRow.Delete
End Sub
This code is in my Add.xlsm file.

I need to execute this code for each and every excel file that I download during automation. I tried executing macro but it is not working fine. Can any one provide any better solution.
Thanks and Regrds,
M.Srikanth

[Als]

Hi,
Your question is answered here. You can call macro from any workbook.

Execute Macro from Personal Macro Workbook

Hi all, I am trying to use the Execute Macro activity to run a macro from my Personal Macro Workbook (PERSONAL.XLSB), but I encounter an exception, which I’ve included below. My input field for Execute Macro is as follows, where “JobsheetExport” is the macro name: “C:\Users\Daniel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!JobsheetExport” Here’s part of the error message (if the full message helps, I can post that too): Message: The range does not exist Source: Execute macro Ex…

[n.balaji10]

use excel application scope of macro sheet first, inside that use normal excel and then exceute macro