Exporting Query Results into a Particular cell (A9)

Paul · Oct 28, 2003

Hi All,
I want to write a procedure that exports a query from
Access into a certain field in an excel file called Paul.
Can someone supply the code to do this?

Gary Walter · Oct 28, 2003

Paul said:
Hi All,
I want to write a procedure that exports a query from
Access into a certain field in an excel file called Paul.
Can someone supply the code to do this?

Hi Paul,

This may get you started:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210288
ACC2000: Using Automation to Transfer Data to Microsoft Excel

Good luck,

Gary Walter