Outputting to Excel

  • Thread starter Thread starter sheetal
  • Start date Start date
S

sheetal

I have created some reports in Access, and want to create a macro that
will open and run and then export to excel. How do I do this?

I have started the macro by writing OpenReport, and naming the report.
I get stuck when it comes to exporting to Excel. Do I need to go into
the VB? If so, what would be the code?

Please help, Thanks

Sheetal
 
Instead of OpenReport use OutputTo
This will export the report named to Excel
Jim
 
In my macro I Use the action open query/output to(set the
export format to excel)
 
You must log in or register to reply here.

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 table to txt file with a variable filename 0
Word to Excel: Export comments with text and line number 0
Output to : Template file 3
Automatic excel open 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
export Access data & enable excel macros 1
OutputTo to Excel question 8
Output the "Created Time/Date" to an Excel file 2

Back
Top