vba functions hypquerymembers error 57704
Hello,
we are using vba functions to get some information from our planning system. some of the connections are woking but some others not with an identified error.
The error we are facing is 57704 and is not in the list of vba errors.
we are able to connect to the system with Z = HypUIConnect(hoja1, "ddelgado", "XXXXXX", "XXXX") 'works
but when we try to use: t = HypGetChildren(hoja1, "Total_CostCenter", 0, vtChildren) we get the error.
What is this error (57704) saying? For all of the functions we get the same number error.
this is for example an example of our code: