Exporting Query Results into a Particular cell (A9)

[Paul]

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]

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