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

[renjithpl]

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