Databases Reference
In-Depth Information
FIGURE 9.27
Results of automated curve-fitting session using Origin.
If ii > 67 Then
monoOptionButton.value = False
Else
monoOptionButton.value = True
End If
Call Multi_Run
DoEvents
Next ii
Call Terminate_Conversation
End Sub
Although DDE is a somewhat dated technology, it continues to be utilized by many software
applications. In the instance where an application has not been updated to support Microsoft COM,
DDE may be the only method to enable external software components to communicate with Excel.
DDE is a tried-and-true system that has nearly all of the bugs hashed out of it and continues to be
widely utilized, which necessitates its coverage here.
9.9
INTERFACING EXCEL AND ORIGIN USING
COM (COMPONENT OBJECT MODEL)
Microsoft COM technology in the Microsoft Windows family of operating systems enables differing
software components to communicate with each other in a Windows environment. COM is used
by developers to create reusable software components, link components together to build applica-
tions, and take advantage of Windows services. The family of COM technologies includes COM+,
Distributed COM (DCOM), and ActiveX Controls. COM is the most current method that can be
employed to link components from differing applications together to build a more robust application
than either component could provide by itself working alone. In this instance, an example will be
created to link Excel and Origin together using COM technologies to create a robust pKa curve-
fitting application.
