Export Query Question

[Richard]

Hi all,

If I open a database window and select "Queries†then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as type to: Microsoft Excel 97-2000 Its exactly what I need. How can
I reproduce this behind a command button?

Richard

 

[PieterLinden via AccessMonster.com]

Hi all,

If I open a database window and select "Queries†then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as type to: Microsoft Excel 97-2000 Its exactly what I need. How can
I reproduce this behind a command button?

Richard

Use TransferSpreadsheet, and pass the query name as the object you want to
export. then call that in the Click event of your command button.