I need to transfer an array from CAR to Excel. I've been trying the OLE commands. Creating the object and worksheet succeed, but for some reason I can't get the Range and/or Cells method/property to work. This works:
Set oXL = CreateObject("Excel.Application") Set oWB = oXL.Workbooks.Add Set oWS = oWB.ActiveSheet oWS.Name = "CAR Data"
But from here I can only change the value of the active cell to the row 1 column 1 array value. I can't seem to move the active cell, or define a range, or resize the active cell. Any ideas? The attempts below all fail (CAR reports that Resize, Range, and Offset are not valid members):