How to call worksheet functions from Access ?
Hi,
I used to be able easily to call Excel functions from outside Excel, like MS
Access with a simple statement as follow:
var = Excel.Application.NormInv(....)
With newer versions of Excel, these functions were grouped in an object
called WorksheetFunction, so I assume the line to call now would be:
var = Excel.Application.WorksheetFunction.NormInv(...)
But this always return me an error 1004, saying it can't read the property
'NormInv' from object 'WorksheetFunction'.
Anybody figured that one out?
Thanks
|