Calling Excel from Access

[Terry Lawson]

All

I would like to run an Excel macro from within the code behind an Access form.



Pls can some one point me in the right direction.

Regards

Terry Lawson

[orange]

'* method for opening the Excel file ...
'
'* if excel is running use it
'* if excel is NOT running, create an instance

If IsExcelRunning() Then
Set xlApp = GetObject(, "Excel.Application")
Else
Do
Set xlApp = CreateObject("Excel.Application")
Loop Until IsExcelRunning()
End If


Look here for more/other info
http://www.pcreview.co.uk/forums/det...-t1642105.html

[Terry Lawson]

Thanks for that.

It's always easy when you know how!

Regards

Terry Lawson