Using Already Open Workbook

[Austin]

Hello,

I am trying to use an unsaved, already open workbook to export data from
access to excel.

To reference the open App I have:

Set xlApp = GetObject(, "Excel.Application")

But not sure what the equivalent would be for the current workbook line.

Any help would be great.

Thanks

 

[Paul]

You would use

Set xlApp = CreateObject(, "Excel.Application")

However, you will need to determine if the GetObject or CreateObject should
be called. You can find the procedure here:
http://www.mvps.org/access/api/api0007.htm

Regards,

Paul

 

[Douglas J. Steele]

Try:

Set wbCurr = xlApp.ActiveWorkbook

 

[Austin]

That works, thanks a lot Doug

Try:

Set wbCurr = xlApp.ActiveWorkbook