Here you go
' First thing, add a reference to excel object
Imports Microsoft.Office.Interop
Try
appExcel = GetObject(, "Excel.Application")
Catch ex As Exception
appExcel = New Excel.Application
xlWorkbook = appExcel.Workbooks.Add
End Try
After that everything works just like using VBA in Excel, which is another topic for another forum. The GetObject function will use an open Excel window if it finds one. Note: it will use the first one that was opened, which is the first one that appears in the processes window if you look.
