you need to create a workbook (excel.workbooks.add or open) and worksheet (workb.ActiveSheet). To grab / send data I like to create a 1D array, set a range (workS.range("A1","A4")) of the same length and go inRange.Value2 = inputArray. [or you could go the other way too]
When you are finished you should set excel = Nothing. Go to your task manager (Ctrl+Alt+Del, then task manager>processes tab) to check if Excel.Exe is still running after your component is finished.
Hope that gets you started!
Ben
(I posted an example file in the Samples and Examples group that uses excel, maybe it could be useful to you?)…