Creation of Pivot Table

Hi @NiranjanKN,

Firstly, Do check EntryMethodName (parameter of Invoke VBA activity), In your macro, the method name is Macro1, so mention the same at EntryMethodName parameter (“Macro1” instead of “Main”).

Secondly, don’t forget to check this checkbox below,



  1. click on Developer
  2. Macro settings
  3. Trust access to the VBA project object model