Executing an Excel based module from within Access

[alanponeill]

I am trying to execute an Excel based module from within Access. Anybody know how I can do this.


Thanks,

Alan

 

[Norie]

Something like this:

Sub Test()
Dim xlobj As Object

    Set xlobj = GetObject("C:\Papers\TestMacro.xls")

    xlobj.Application.Run "TestMacro"

    Set xlobj = Nothing

End Sub

BTW what are you actually trying to do?

 

[alanponeill]

THAT WAS PERFECT. THANKS VERY MUCH.

ALAN