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.