VBA - What is OLE and DDE? Explain.

GeekInterview.com > Interview Questions > Programming > VBA

Go To First | Previous Question | Next Question

VBA | Question 39 of 62

What is OLE and DDE? Explain.

Total Answers and Comments: 2

Last Update: September 12, 2006 Asked by: Beena

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 12, 2006 02:50:54

Dharmendra Dixit

RE: What is OLE and DDE? Explain.

Object Linking and Embedding (OLE) is a distributed object system and protocol developed by Microsoft.OLE allows an editor to farm out part of a document to another editor and then reimport it. For example a desktop publishing system might send some text to a word processor or a picture to a bitmap editor using OLE. The main benefit of using OLE next to reduced file size is the ability to create a master file. References to data in this file can be made and the master file can then have changed data which will then take effect in the referenced document.DDE stands for Dynamic Data Exchange. That's exactly what it does and nothing more. It sends data between applications using Windows messages according to a documented protocol. Saying that DDE is old-fashioned and is being replaced by COM is something you see repeated parrot fashion over and over again. DDE and COM do not work in the same way and they solve different problems. Here are some points of difference:

Is this answer useful? Yes | No

September 12, 2006 04:40:49

suhani02

Member Since: September 2006 Contribution: 2

RE: What is OLE and DDE? Explain.

Object Linking and Embedding (OLE) is a distributed object system and protocol developed by Microsoft. OLE allows an editor to farm out part of a document to another editor and then reimport it. For example a desktop publishing system might send some text to a word processor or a picture to a bitmap editor using OLE. The main benefit of using OLE next to reduced file size is the ability to create a master file. References to data in this file can be made and the master file can then have changed data which will then take effect in the referenced document.Dynamic Data Exchange (DDE) is a technology for communication between multiple applications under Microsoft Windows and also OS/2. Although still supported in even latest Windows versions it has mostly been replaced by its much more powerful successors OLE COM and OLE Automation. However it is still used in several places inside Windows e.g. for Shell file associations.

Is this answer useful? Yes | No

Question Bank

Related Articles

User Name		Remember Me?
Password