0 Replies Latest reply: May 26, 2012 5:04 AM by Renjith Pl RSS

    Export to excel and save as in the file name based on variable input/selection made

    Renjith Pl

      Hi All,

       

      I need a macro where i need to export a pivot table/object to excel into a specified location but with different file names. The file names should be based on a variable input or selection made.

       

      Eg. When i open the location path, i should see excel files LIke : ABC.xls, XYZ.xls etc....

      ABC and XYZ are my values in a list box.

       

      Thanks

      Ranjit