Copy Records from Access into Excel

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

How can I copy all the records shown in a form with a filter applied to a
excel spreadsheet using visual basic. I want to setup a button that when
pressed, it does a [CTRL-A] [CTRL-C] then opens excel to a blank sheet and
pastes the records in the sheet.

Not having much luck with this.

Thank you in advance for your help!!!!
Mike
 
How can I copy all the records shown in a form with a filter applied to a
excel spreadsheet using visual basic. I want to setup a button that when
pressed, it does a [CTRL-A] [CTRL-C] then opens excel to a blank sheet and
pastes the records in the sheet.

Not having much luck with this.

Thank you in advance for your help!!!!
Mike
Click to expand...

use the "docmd.transferspreadsheet"
then provide the correct parameters
one of them is the dataset to export

grtz
 

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

Macro to copy value in field and insert it into filter 2
Exporting large Access query to Excel 1
File sharing lock and append paste 3
VBA: How can I use a string variable as autofilter criteria? 4
Copy record into same table 1
Form Filter Problem 2
The Ctrl + D command from Excel 3
passing values from access to excel 1

Back
Top