Code to transfer to excel

[spacepro]

Hi Guys,
Done a search of the forum but not specific for what I want.

Can you help. Every week I run a report based on two dates, also at the same time an invoice report is done in excel by copying and pasting the info from the report.

At some point we are going to alter access to carry out all of our invoicing requirements, but until them I am after sample code on how to export the data from access into excel worksheet but to a certain range of cells e.g(A1:A10 and G1:10)

This would say us a lot of time until we make the changes to the db .

Many Thanks
Andy

 

[Fornatian]

try:

http://www.mvps.org/access/modules/mdl0035.htm

alternatively, if you are looking for quick indirect way use the Docmd.OutputTo method to output the records in XLS format, then link your invoice report to the outputted worksheet.

Every time you open the excel invoice report after outputting the records all the information will automatically update.

 

[spacepro]

Thanks Fornation.