Export to Excel in Macro ?

D

David

I have a query that works and I need to export the results
to an Excel spreadsheet. I can do this manually but I'd
like to create a macro that runs the quesry and then does
the export to Excel in the My Documents folder.
However, I cant find a macro command that does this.
I'm using Access 2000 and Excel 2000.
 
D

David

I figured this one out now, it was the 'Transfer
Spreadsheet' command ... who'd have guessed!
 

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
Using Office Forms and dynamically updating the excel backend 0
VBA - exporting serial letters to single documents 0
Integrating information from Word to Excel (not mail merge) 1
VBA Export to PDF 0
Drop down list control value in vba 2
Word macro that can call cells out of Excel for a find and replace 0
Embed the same Excel multiple times 0

Top