Exporting to Excel Date Stamped File

[BED]

I have a form in which a user can export any number from 1-8 tables to a excel workbook. I have it fully functional but i need help including a date stamp on the file.



Ex.
Today export table 1 and 2 to filename Example_TodaysYearTodaysMonthTodaysDate.xls

Tomorrow
Export table 3 and 4 to filename
Example_TodaysYearTodaysMonthTodaysDate.xls

It has to create the document every time.

Any thoughts

i have this in the filename portion and it doesnt work

Example_& DatePart("YYYY",Date()) & " " & DatePart("M",Date()) & " " & DatePart("d",Date()) .xls

[pkstormy]

I would create a variable and then populate that variable with your datepart equation. You can do a msgbox MyVariable to see what it looks like after you populate it in code. If it looks ok, then use that variable as the parameter part for you filename (versus trying to export AND do a DatePart in the same line of code.)