This example resets any previously run simulation, then clears the current assumption list, adds B5 to the assumption list, and turns on the assumption parameter option (the second cbChaChosen use). Other assumption preferences default to the current setting in the Create Report dialog. Finally, the example generates the report. No forecast or simulation charts will appear, since CB.ResetND cleared all previous simulation information.
CB.ResetND CB.CheckData CB.CreateRptND cbRptChooseAssum, cbChaClearList CB.CreateRptND cbRptChooseAssum, cbChaChosen Range("B5").Select CB.CreateRptND cbRptChooseAssum, cbChaAdd CB.CreateRptND cbRptChooseAssum, cbChaChosen Cb.CreateRptND cbRptAssumParam, True CB.CreateRptND cbRptOK