HomeTroubleshooting@RISK for Excel: Other IssuesGraphDistribution Method in VBA Fails

8.26. GraphDistribution Method in VBA Fails

Applies to: @RISK 7.5.1 only

My VBA code worked fine in 7.5.0, but when I updated to 7.5.1 it started failing in the GraphDistribution method. My error message is

Invalid argument.
Argument: Simulation

or

Method 'GraphDistribution' of object '_RiskSimResultCollection' failed

This is a bug unfortunately introduced in @RISK 7.5.1. It affects GraphDistribution or any other method whose first argument is a variant for identifying the result and whose second argument is an optional simulation number. If you supply the simulation number all is well, but if you leave it out then @RISK displays one of the above errors.

This bug will be fixed in our next release, but we already have a patch available so that you don't have to change any of your VBA code. Download the attached AtRiskOL.dll file to a convenient location, such as your desktop. Then, open the folder C:\Program Files (x86)\Palisade\RISK7 in 64-bit Windows, or C:\Program Files\Palisade\RISK7 in 32-bit Windows, and drag the downloaded AtRiskOL.dll file into that folder. Windows will probably ask you for permission to access the folder and also to overwrite the existing file.

Last edited: 2016-11-04

Downloads

This page was: Helpful | Not Helpful