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