Exporting a report to excel through a macro

  • Thread starter Thread starter guidop12
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report to txt 2
Export table to txt file with a variable filename 0
Access Macro to export table to Excel then run Excel macro 1
Exporting multiple reports via macro 2
export Access data & enable excel macros 1
close excel in macro 1
Problem in exporting the access 2007 report to excel 3
Pause Macro 1

Back
Top