Access 2007 Report Output to Excel

Hi,

I am new to VB and trying to get Excel output from Access 2007-Report
using:
DoCmd.OutputTo acOutputReport, rptName, acFormatXLSX, OFileName, True

I keep on getting:

Run-time error '2282':
The format in which you are attempting to output the current object is not avaialabe.

I would like to go from Report as font and color formattings are completed.

Any suggestions to work around :-)

Thanks.
Suzanne

re: Access 2007 Report Output to Excel

Microsoft has disabled this feature. Why? I don't know.

Exporting reports to Excel in earlier versions always had little glitches, but most of us either knew ways to avoid those, or were willing to live with it.

Check out this Knowledge Base article

http://support.microsoft.com/kb/934833


One workaround not mentioned in the MIcrosoft KB article is that you CAN export a FORM to Excel.

Convert your report to a form (a manual copy/paste process), then export the form to excel.

re: Access 2007 Report Output to Excel

how do i do your alternative suggestion in vba

Thanks
Joe