How to create a pivot table from a data table

[caduque (Cedric)]

Hi!

Can someone help me create a pivot table from a data table? See sample file below

Sample.xls (36.5 KB)

I want my pivot table to look like this.

Thanks!

[samir (Samir Mohite)]

Hi @caduque,

Try this,

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…

[caduque (Cedric)]

Hi!

Getting the error below.

My text file is attached for reference. Thanks!

macro.txt (2.8 KB)

[samir (Samir Mohite)]

@caduque have a look here,

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, [image] Steps: [image] click on Developer Macro settings Trust access to the VBA project object model

[caduque (Cedric)]

Hi!

Still getting the same error. Tried replacing the EntryMethodName with every possible value but having no success

[caduque (Cedric)]

Hi @samir,

Attaching my xaml file here and the text file I’m using. Hope you can check them.

SamplePivot.xaml (4.9 KB)

macro.txt (2.6 KB)

For the excel file where the pivot is created, I’ve already followed the instructions on the link you gave me.

Thanks!

[caduque (Cedric)]

Hi @Palaniyappan,

Could I have your spare time to help me debug my sequence? Please note that my excel file is a macro enabled workbook.

Here’s my xaml and text file

SamplePivot.xaml (5.0 KB)

Macro1.txt (2.2 KB)

[Palaniyappan (Forum Leader)]

Kindly try once with normal .xlsx instead of .xlsm file and inside the scope use the same invoke VBA activity

Cheers @caduque