Using the OLE control, programmer can embed or link objects from OLE server programs like Excel. In this way, programmer can present an application with a spreadsheet to programs users. The OLE control is an intrinsic VB control, and it appears in the tool box. Following is method of creating & embedding an OLE object:
1. Add an OLE control to a form now by double-clicking the OLE control tool. The OLE control appears in the form, and a moment later, the Insert Object dialog box appears.
2. By using this dialog box a new OLE object in OLE control can be created and embedded. Create New option must be selected.
3. In the next step the name of the OLE server application, which is to be used by the programmer, is found and selected. Then click on OK.