K ksor Registered User. Local time Yesterday, 19:41 Joined Feb 8, 2018 Messages 70 Mar 27, 2018 #1 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 ?
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 ..forever waiting... waiting for jellybean! Local time Today, 10:41 Joined May 7, 2009 Messages 20,276 Mar 27, 2018 #2 There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation.
K ksor Registered User. Local time Yesterday, 19:41 Joined Feb 8, 2018 Messages 70 Mar 27, 2018 #3 arnelgp said: There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation. Click to expand... I can't even Google anything on "Excel FuncName()" ? Do you have a link to some sample code ?
arnelgp said: There is a Worksheetfunction.funcname() that you can use on an ibstance of excel automation. Click to expand... I can't even Google anything on "Excel FuncName()" ? Do you have a link to some sample code ?
S static Registered User. Local time Today, 03:41 Joined Nov 2, 2015 Messages 823 Mar 27, 2018 #4 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
K ksor Registered User. Local time Yesterday, 19:41 Joined Feb 8, 2018 Messages 70 Mar 27, 2018 #5 static said: funcname = your function's name ? Anyway, functions use brackets MsgBox xl.Run("yourfunction") myvariable = xl.Run("yourfunction") edit++ otherwise they're just subprocedures Click to expand... DOOO ... how simple can it be - THX !
static said: funcname = your function's name ? Anyway, functions use brackets MsgBox xl.Run("yourfunction") myvariable = xl.Run("yourfunction") edit++ otherwise they're just subprocedures Click to expand... DOOO ... how simple can it be - THX !
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 10:41 Joined May 7, 2009 Messages 20,276 Mar 27, 2018 #6 Value= xl.Worksheetfuncton.theFunctionName()