How do I use HypExecuteCalcScriptEx properly?
I had a macro that replicated user's actions: it changed parameters in the form, updated some values, and submitted the form. Essentially, doing something like that:
sts1 = HypSetActiveMember("Entity", Entity_POV)
sts2 = HypSetActiveMember("Product", Product_POV)
X = HypMenuVSubmitData()
Entities and Products were kept in an Excel sheet:
The macro was taking them one combination at a time.
All Entity X / Product X intersections are valid; not all Entity X / Product Y intersections are. As a result, I can't just switch from, say Entity 1 / Product 1 intersection to Entity 2 / Product 2, because while doing that I will temporarily encounter a situation where I will have Entity 1 / Product 2 intersection, and this intersection may be invalid.