I am attempting to write a code that will load a .dat file into DIAdem, then save that file as an .xls (excel) file. My problem is that the checkboxes do not seem to be recognized in further lines of the code. The BenTest.sud file simply brings up a dialog box with two checkboxes (both initially unchecked). The green portion works fine, the error occurs in the red line, and the error message is shown below in red. The red line is simply a troubleshooting line of code to determine the boolean value of the checkbox.
Call DataLoadHdFile("C:\Data\Testing\BensTest\processed 1_COMPASS NCAP 060816_DIAdemHeader_BINARY.dat")
Call DataLoad("C:\Data\Testing\BensTest\processed 1_COMPASS NCAP 060816_DIAdemHeader_BINARY.dat")
Call SUDDlgShow("BensDialog", "C:\Data_Processing_DiaDem10\Aut\BenTest.sud")
MsgBox("CVSCheckBox: " & ExcelCheckBox.Value)
if ExcelCheckBox_ = 1 then
Call ExcelExport(, , 1)
else if CSVCheckBox_ = true then
MsgBox("CSV checkbox selected.")
else
MsgBox("No Conversions Selected.")
end if
end if
Error Message
Object Required: 'ExcelCheckBox'