Calling Excel Functions from Access

[Matt]

I have a function in VBA in an Excel file. I want to
open up Excel programatically from Access and then run
that function (and provide it parameters). How do I do
this?

Thanks!
-Matt

 

[SA]

Matt:

Stop by www.mvps.org/access and look in the modules area. I know there's
an example of calling a function in Excel in that section.