How to Append Date to Filename??

[rich808]

I'm making a macro to output a report to an Excel spreadsheet using OutputTo and would like to add the date to the filename since this is done each day and the files need to be different. So I'd have something like "Output" as the base filename and "Output20050628" as the final filename. Would someone please help me out on this? Thanks in advance.

 

[MStef]

Hello rich!
Look at "DemoExpToExcelA2000.mdb"

 

[DaveJHPT]

"Output" & Format(Date(),"yyyymmdd") & ".xls"

Dave

 

[rich808]

Thanks Dave and MStef! I tried what Dave sent and it worked perfectly!