How to populate an Excel worksheet with output from HypQueryMembers function
Summary
How to populate an Excel worksheet with output from HypQueryMembers functionContent
Hi. I'm trying to get the children of a member without having to do an ad-hoc and zoom. I am automating a report using VBA and want to make it as fast as possible. I tried using HypQueryMembers, but I can't get the members to show up in a worksheet or listbox. All I've been able to do is get the return code - 0 for successful and so forth. Does anyone have any idea how to get the actual output of the function? Below is my code as it stands right now.
0