Exporting a report to excel through a macro

[guidop12]

Is there a way to export a report made in access to excel through a macro.

 

[Steve Schapel]

Guidop,

Theoretically yes, via the OutputTo action in your macro. In practice,
however, this will likely lead to despair. In practice an Access
report, which is primarily a presentation object, is usually of a very
different structure compared with a spreadsheet. Therefore, it is wise
to only think of exporting tables or queries to Excel.