add an option to the filename

Hi there guys,

Does anyone have any idea how this can be done?

The report runs with certain options filters like Customer account number and then is saved with that filter in the excel file name.

i.e. a report for Customer Account number 111131 on 31/03/09 should be saved as 111131_310309_Quotation.xls

any clever ideas?

Maybe even some vba code?