Creating Pivot Table in the background

Help
3

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)
2 Likes