Export to Excel in Macro ?

  • Thread starter Thread starter David
  • Start date Start date
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.
 
I figured this one out now, it was the 'Transfer
Spreadsheet' command ... who'd have guessed!
 
Back
Top