Dont able to run macro

[DhanashreeLokhande (Dhanashree)]

Execute Macro: Cannot run the macro ‘Reorder_Columns’. The macro may not be available in this workbook or all macros may be disabled.
I can not able to macro…suggest me

[Lahiru.Fernando]

Hi @DhanashreeLokhande

Is the macro available in the macro enabled excel file? And is the macros enabled in the excel file that you are trying to run? Why I ask this is the error says that it is not available or not enabled.

[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…