How to get return value from an Excel-function run in Access ?

[ksor]

I can run an Excel-function, placeEvent, from within Access by:

xlApp.Application.Run "placeEvent", ... function arguments given here ....

but how can I get the value returned by the Excel-function ?

 

[arnelgp]

There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation.

 

[ksor]

There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation.

I can't even Google anything on "Excel FuncName()" ?

Do you have a link to some sample code ?

 

[static]

funcname = your function's name ?

Anyway, functions use brackets

MsgBox xl.Run("yourfunction")

myvariable = xl.Run("yourfunction")

edit++ otherwise they're just subprocedures

 

[ksor]

funcname = your function's name ?

Anyway, functions use brackets

MsgBox xl.Run("yourfunction")

myvariable = xl.Run("yourfunction")

edit++ otherwise they're just subprocedures

DOOO ... how simple can it be - THX !

 

[arnelgp]

Value= xl.Worksheetfuncton.theFunctionName()