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
 
Back
Top