Report Output

[Drunkenneo]

I am using code for output to a folder


DoCmd.OutputTo acOutputReport, "payment_log", acFormatXLS, "E:\intel\Redemptions\APAC\ICICI\Database\Attachments\" & format(Now(),"dd/mmmm/yyyy) & "_Finance.xls"

I get the error that microsoft access is not able to export.

Please Help!!

 

[pbaldy]

As answered elsewhere,

For starters, get rid of the slashes in the date, which are likely invalid in a file name.

 

[Drunkenneo]

:banghead: missed by an inch...thanks

 

[pbaldy]

No problem.