Exporting a report to excel

M

Matthew

I have created a VB backed interface at work in order to
run some SQL statements to bring me a report. I want that
report not to open in access but in excel...I can open the
report in access and everything works but I don't want it
to open in access but in excel...So far I have written
enough VB to open a spreadsheet when I run the code but I
don't know how to call the report and open it in the
spreadsheet...Do I have to call it as an object or what?
 

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 a VBA subroutine 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
Integrating information from Word to Excel (not mail merge) 1
Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
Linking data in MS Word into Excel 5
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top