DoCmd.OutputTo acOutputQuery, "Exch_Compare", acFormatXLSX, "M:\Exceptions Research\OutPut\(NEED TODAYS DATE HERE)Exchange.xlsx", False
Hi-
I need to add todays date to the output file name. It needs to change every day (Today "3-8-2011Exchange.xlsx) then (tomorrow 3-9-2011Exchange.xlsx)
Its prob a simple code, but the Access Help is not giving me the right answer.
Thanks
Hi-
I need to add todays date to the output file name. It needs to change every day (Today "3-8-2011Exchange.xlsx) then (tomorrow 3-9-2011Exchange.xlsx)
Its prob a simple code, but the Access Help is not giving me the right answer.
Thanks