8/20/2017 6:11 PM | |
Joined: 8/20/2017 Last visit: 10/9/2024 Posts: 1 Rating: (0) |
Dear experts, I am trying to get the tag from a dynamic dialog property from a customized object. My code works when I read a boolean setted up dialog (Datatype). But when the dyn dialog is set to a bit (datatype) thats is evaluate from a tag. the code in VBA echos an error. the error: Object variable or With block variable not set (Error 91). The picture below descript the bit evaluation I use in the dynami dialog. I searched for the error and is descriped I forget the with statement. But after 2 days still no succes in running the code properly. My code below: If ActObj.Properties.Item(STEP).DisplayName = "WARNING" Then ExcelKolomTab1 = 7 objExcelApp.cells(ExcelRijTab1, ExcelKolomTab1).value = ActObj.Properties("WARNING").Dynamic.SourceCode End If This code runs correct and this is a dynimic dialog with a boolean expression. If ActObj.Properties.Item(STEP).DisplayName = "HWFAULT" Then ExcelKolomTab1 = 10 objExcelApp.cells(ExcelRijTab1, ExcelKolomTab1).value = CStr(ActObj.Properties("HWFAULT").Dynamic.SourceCode) End if This runs the error when the dynamic of this property is set to bit. I tried the it with the with statement but still same error: If ActObj.Properties.Item(STEP).DisplayName = "SIMU" Then ExcelKolomTab1 = 9 Set objVBScript = ActObj.Properties("SIMU").Dynamic With objVBScript strCode = .SourceCode & "'Add some comments" .SourceCode = strCode End With Hopefully there is an answer to my problem Kind Regards, Nick ------------------------------------------------------------------------------------------ |
Last edited by: The Helping Hand at: 8/21/2017 12:22:43 PMNew subject after splitting |
|
Follow us on