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.