Copy query results to an Excel object on a form.

[Sniper-BoOyA-]

Good morning/afternoon everyone,

I have got an Excel spreadsheet with a graph etc. but i'd like to use Access (2003) instead.

Ive noticed that making graphs in Access is pretty basic and does not give you the options Excel does. So ive been trying some stuff in VBA and managed to export the results of the query to a .xls file using the following code;

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Query_Controlekaart_Druk_28d_eindberekening", "C:\test\excel.xls"

Works great, but that means id have to work with seperate excelfiles.
I have also noticed you are able to insert an Excel object into your form using Insert --> Object --> Microsoft Excel Worksheet (Spreadsheet).

Is it possible to copy results of a query/table into that Excel object?
Ive tried to replace the "C:\test\Excel.xls" path with forms!formname!objectname but it does not seem to work.

Any ideas? I have used the 'search' option hoping someone posted a similar thread, but no luck.

Thanks.