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