You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I use HypExecuteCalcScriptEx properly?

Received Response
3
Views
6
Comments

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)

<change values>

      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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!