Dont able to run macro

[samir (Samir Mohite)]

Hi @DhanashreeLokhande,

I’ll suggest you to use Invoke VBA activity.

1. Firstly save macro code from excel in .txt file.
2. Take Invoke VBA activity inside Excel Application Scope.
   Specify the path of txt file in —> CodeFilePath parameter. (e.g —> “ExcelMacro.txt”)
   & macro method name in —> EntryMethodName parameter. (e.g. —> “Macro1”)

Prerequisites, don’t forget to follow steps below before running.

Creating Pivot Table in the background

Hi @Michael_de_Borja I’ll suggest you to record macro in excel with creating Pivot table and use Invoke VBA activity to invoke that vba script. For that follow these steps :- Record macro with creating Pivot table, Save that Macro in a text file with a .txt extension. call the text file in invoke VBA code Activity. (and mention that method name in activity) place the invoke vba activity in a Excel Application Scope Activity. If any arguments need to pass to the method, pass in the “Entry Me…