Easy way to export to Excel with unique file name based on selection?

[#1]

I've seen a couple of examples doing this with macros. Before I get into all that, I wondered "Is there an easy way to specify the file name using the selected value of the "sales rep" field, and the "startdate" variable?"

[#2]

Hi All,

i have tried this above macro but getting

SaveAs method of Workbook class failed error