Hi

Im having some troubles talking to excel from my vb addin I made.
This code to send data to excel from a db works great:

Dim xlApp As Excel.Application
Dim xlWb As Workbook
Dim xlWs As Worksheet

Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.Workbooks.Add
Set xlWs = xlWb.Worksheets("Sheet1")

Now im now trying to pick up the changes and send it back from the active excel workbook, I cant seem to reference the active workbook...
This is the code im using:

Dim xlApp As Excel.Application
Dim xlWb As Workbook
Dim xlWs As Worksheet

Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.ActiveWorkbook
Set xlWs = xlWb.ActiveSheet

Any ideas from anyone ?

Thanks andy...

What happens when you try this?