Standard format for Excel cells is Sheet1!$A$1 for Sheet1 cell A1

Hi Rob

First set a reference to the "Microsoft Excel x.x Object Library"
(Tools>References from the code window)

Then you can use code like this:

 Dim xlApp As Excel.Application
 Dim xlWkb As Excel.Workbook
 Dim xlSht As Excel.Worksheet
 Set xlApp = CreateObject("Excel.Application")
 Set xlWkb = xlApp.Workbooks.Open("C:\Test.xls")
 Set xlSht = xlWkb.Worksheets("Sheet1")
 With xlSht
   .Range("A1") = "Hello"
   .Range("A2") = "World"
   .Range("B10") = 9999
 End With
 xlWkb.Close SaveChanges:=True
 xlApp.Quit
 Set xlSht = Nothing
 Set xlWkb = Nothing
 Set xlApp = Nothing