Exporting Report to Certain fields in existing Excel Spreadsheet

[ximistar]

Hi everyone,

I am trying to export a report to an Excel spreadsheet and I want the data in the report to be pasted into certain fields into an existing excel spreadsheet that already has been created with formulas.

Is this possible? if so how!!!!

Thank you

 

[Ranman256]

You can't export a Report, you export data.
If you want to place the data in a certain cell block, you must take control of XL.

Set XL =excel.application
With XL
    'Open file 
...
  Set rst = currentdb.openrecordset("qsQuery")
  .rsnge("g4").select
  .copyfromrecordset Rst
...