Query to display its result in Excel

S

sprinklingtarn

Joined
Jul 6, 2005
Messages
11
Reaction score
0
I am running a query in Access 2003 via VB Code DoCmd.OpenQuery and AcPreview. Its fine.

Occasionally I then manually use Office Tools Publish in Microsoft Excel to display in a spreadsheet.

How can I run the query and get it to automatically display the result in Excel via VB code. I DONT need to save the spreadsheet I just want it displayed on screen but dont want to have to select Office Tools etc.

OutputObject is not what I want as this creates a spreadsheet but does not then display it.

Thanks
 

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

Create Excel Lab test results 1
Display Query Results on top of a Form 1
Query Returning Multiple Results 1
How to display multiple IIf results in one column 1
Display Query from form in Foreground 6
How to update data in a query 1
query is not updatable;; urgent 1
Run query based on results of previous query using code 4

Back
Top