Hi.
I need to use EXCEL SOLVER function in my VBA project in ACCESS.
If someone knows how I can connect SOLVER to ACCESS, please let me know.
Thank you.
Hi All!
The problem is following:
I want to get as QUERY result the value of the function, that uses another function which PARAMETER is ARRAY!!! So there is Function FA(ARRAY()) which returns one more ARRAY as result and there is one more function FB(ARRAY()) which returns STRING Value.
So...
I am trying to use the function (enclosed in another function), which I created in VBA in one Query, but I constantly get the Error - Undifined Function. I think there is a problem about ARRAY in this function, but it works as expected in VBA, not in Query.
There is a small example of what I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.