Creating Pivot Table in the background

I have a template excel file where I place datatable using Append range.
After appending, I need to create a pivot table using the written data, in the same sheet.

I need it to be done in the background, without opening Excel.

Please advise!

Thank you!

Not sure of a way you could do this without opening excel i’m afraid. You could minimise the excel window as soon as it appears and run a VBA script possbily?

1 Like

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 :-

  1. Record macro with creating Pivot table, Save that Macro in a text file with a .txt extension.
  2. 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.
  3. If any arguments need to pass to the method, pass in the “Entry Method Parameters” (to make range dynamic)
1 Like

Thanks!

aww. thanks tho!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.