Hi, 1. Microsoft Forms 2.0 Object lib. provides the MSForms2.0 Controls. Just a few. To know more about each of the referenced components, in VBE press F2 to bring up the object browser. In the first combo-box (upper-left - All Libraries), select the appropriate one, and you will know what objects, methods, classes etc. are exposed by that library. As for the ActiveX reference, better to google the file name to know more.
2. Coming to OLE and DDE, take a look at the following link, that might help-- http://forums.techarena.in/software-development/1133040.htm Regards Ajit -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Yu Sent: Thursday, May 07, 2009 7:12 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ general discussion on DDE OLE ActiveX in VBA project Hi guys, While I browse the Tools-->References in VBA , I notice that there are lots of references, basically classified into 4 groups: Type Libraries(*.olb, *.tlb, *.dll) Executable Files (*.exe, *.dll) ActiveX Controls (*.ocx) All Files (*.*) I can see currently my VBA project has referenced to Visual Basic for Applications, Microsoft Excel 12.0 Object Library, OLE automation and Microsoft Forms 2.0 Library as well as Office 12.0 Object Library. My first puzzle is about ActiveX vs. Forms 2.0 . I can see that if I didn't add reference to ActiveX controls,then my Form doesn't have controls toolbox, after I add reference to ActiveX, the Controls appear in the toolbox. So what is the use of Microsoft Forms 2.0 library there? From its name, I assume it should also provide form controls. I can see ,by default, VBA project has reference to OLE automation . And I hear some senior guys in company that they used DDE back in the old days. I couldn't even find DDE in the reference window. How DDE differentiate it from OLE.(OLE is just an upgrade of DDE?) And how they are related to ActiveX? As far as I understand, DDE is quite old technology for sharing data between applications, like writing data into Excel cell from your own program. OLE and ActiveX are relatively new, based on COM. When I write vba code in Excel to manipulate Word, am I using OLE or ActiveX or DDE? How can I control which one to use? which one is better? we can discuss these stuff here:) Regards Yu Zheng --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
