لطفا منتظر باشید ...
Creating C++ Components for VBA
Not all programmers of Microsoft Windows–based applications will be C++ programmers, especially if they have to learn the intricacies of COM theory. If you've been paying attention, you've probably noticed a trend in which C++ programmers produce reusable modules. Programmers who use higher-level languages (Visual Basic, VBA, and Web scripting languages, for example) consume those modules by integrating them into applications. You can participate in this programming model by learning how to make your software script-friendly. Automation is one tool that the Microsoft Foundation Class library supports. ActiveX controls are another tool for C++/VBA integration and are very much a superset of Automation because both tools use the IDispatch interface. Using ActiveX controls, however, might be overkill in many situations. Many applications, including Excel, can support both Automation components and ActiveX controls. You'll be able to apply all that you learn about Automation when you write and use ActiveX controls.
Two factors are responsible for Automation's success. First, VBA is supported by most Microsoft applications, including Microsoft Word, Microsoft Access, and Excel, not to mention Microsoft Visual Basic itself. All these applications can be linked to other Automation-compatible components, including those written in C++ and VBA. For example, you can write a C++ program that uses the text-processing capability of Word, or you can write a C++ matrix inversion component that can be called from a VBA macro in an Excel worksheet.The second factor underlying Automation's success is that dozens of software companies provide Automation programming interfaces for their applications, mostly for the benefit of VBA programmers. With a little effort, you can run these applications from C++. You can, for example, write an MFC program that controls the Microsoft Visio drawing program.Automation isn't just for C++ and VBA programmers. Software tool companies are already announcing Automation-compatible, Basic-like languages that you can license for your own programmable applications. One version of Smalltalk even supports Automation.
