Question:
How can I access a formula which is inside an XObject to use the LoadFormulaValuesQuiet method in an XControl?
Solution:
To do so, you must use the following script on a button inside the XControl:
'Gets the full path of the XObject
ObjPath = XCFormula.Source.PathName
'Concatenates the XObject path with the Formula name
FormulaName = ObjPath & ".Formula1"
'Loads Value1, in Unit1 of the Formula
Application.GetObject(FormulaName).LoadFormulaValuesQuiet "Unit1", "Value1"
NOTE: For more information, see the attached application.
Attachments:
