Creation of Pivot Table

Help
, ,
7

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,

image

Steps:

image
image1208×447 32.3 KB

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