1 Reply Latest reply on Jul 8, 2012 11:06 AM by petros.chatzipantazis

    Running the Reshape Data macro automatically (VBA)

    Alistair Knock

      Hi,

       

      I have a number of Excel files which need to be modified and then reshaped in the same sequence each time; I'd therefore like to automate this using a macro which runs on every file in a folder, would do some preparatory work on the Excel workbook and then run the Reshape Data routine in the Tableau Reshaper Add-in.  Is this possible (they may not be public) and if so can you share the subroutine/function name and any arguments which can be passed to it?

       

      e.g.

       

      Application.Run "Tableau.xla!ReshapeData", "$B$2"