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

ksor

Registered User.
Local time
Yesterday, 16:25
Joined
Feb 8, 2018
Messages
70
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 ? :confused:
 
There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation.
 
There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation.

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

Do you have a link to some sample code ?
 
funcname = your function's name ?

Anyway, functions use brackets

MsgBox xl.Run("yourfunction")

myvariable = xl.Run("yourfunction")

edit++ otherwise they're just subprocedures
 
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 !
 
Value= xl.Worksheetfuncton.theFunctionName()
 

Users who are viewing this thread

Back
Top Bottom