Output query to excel

T

Tamer Seoud

I created a user interface in Access that enables users to
view and print out reports. Some of the reports have to be
on Excel. Therefore, I want to output some queries to
Excel. What is the code for doing this from an event click?
Thanks for your help

Best Regards,
Tamer
 
J

John Nurick

Hi Tamer,

DoCmd.TransferSpreadsheet

I created a user interface in Access that enables users to
view and print out reports. Some of the reports have to be
on Excel. Therefore, I want to output some queries to
Excel. What is the code for doing this from an event click?
Thanks for your help

Best Regards,
Tamer
Click to expand...
 

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

Need Help with Macro Security 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Automate shape report 0
VSTO C# add in Outlook.Appointment error 0
Integrating information from Word to Excel (not mail merge) 1
Export Data from Report or Query to Excel 1
Embed the same Excel multiple times 0
outlook data file password dialog 0

Top