Docmd output to sample

Hi, all.

Can anyone help me how to export reports to excel files and name them as creation date such as 05232004? I had tried Access help, but it didn't show me any sample code how to use docmd.outputto code.

Please help.

On Sun, 23 May 2004 00:16:02 -0700, Stephen wrote:

Hi, all.

Can anyone help me how to export reports to excel files and name
them as creation date such as 05232004? I had tried Access help,
but it didn't show me any sample code how to use docmd.outputto
code.

Please help.

DoCmd.OutputTo acOutputReport, "ReportName", acFormatXLS,
"c:\YourFolderName\" & Format(Date, "mmddyyyy") & ".xls"

File name today would be
05232004.xls


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Hi Stephen,

Sorry to jump in but have a suggestion for ease of use/locating/sorting:
I would rather use "yyyymmdd" as the format. You will find it much easier
and better to locate afterwards.

Alp

"fredg" wrote in message
...
On Sun, 23 May 2004 00:16:02 -0700, Stephen wrote:

Hi, all.

Can anyone help me how to export reports to excel files and name
them as creation date such as 05232004? I had tried Access help,
but it didn't show me any sample code how to use docmd.outputto
code.

Please help.

DoCmd.OutputTo acOutputReport, "ReportName", acFormatXLS,
"c:\YourFolderName\" & Format(Date, "mmddyyyy") & ".xls"

File name today would be
05232004.xls


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Dear Fredg.

Thank you so much, it works like magic. ^^