Exporting query fields to specific Excel cells

[TUSSFC]

Is this possible?

I have a query which gives 5 fields.
I have an excel file formatted with a specific layout and 5 empty cells for the query results.

Is there any VBA I can use to copy the query data to those specific cells on the fly???

v: Office 03

 

[namliam]

This is for fetching data from excel, but writing to it is pretty much the same

http://www.access-programmers.co.uk/forums/showthread.php?t=148065

 

[KenHigg]

You can open the spreadsheet in Access and do as you please. Here is a pc of sample code:

Dim xlApp As Excel.Application
         Dim xlBook As Excel.Workbook
         Dim xlSheet As Excel.Worksheet
         Set xlApp = CreateObject("Excel.Application")
         Set xlBook = xlApp.Workbooks.Add
         Set xlSheet = xlBook.Worksheets("Sheet1")
         xlSheet.Range(Cells(1, 1), Cells(10, 2)).Value = "Hello"
         xlBook.Saved = True
         Set xlSheet = Nothing
         Set xlBook = Nothing
         xlApp.Quit
         Set xlApp = Nothing

(You have to have excel references set)