ActiveX DLL:

It is an in process server. It runs within the application time.

ActiveX Exe:

It is an out of process server. MS-Excel is an activex exe.

when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that.

Visual basic can be used for server side scripting. A component designed with Visual basic will not have any user interface instead provides the functionality of Active X to other programs via COM. This form of technique allows server side functionality and add in module.

Dim obj as OBJ.CLASS with eitherSet obj = New OBJ.CLASS orSet obj = CreateObject(OBJ.CLASS?) orSet obj = GetObject( , OBJ.CLASS?)orDim obj as New OBJ.CLASS 

DAO (Data access object ) is used for accessing data before ado it was used for database installed on same sys where the application resides.

RDO (Remote data object ) is used for accessing remote data

ADO (Active data object ) most powerful till date it is nothing but combination of both DAO and RDO 

DDE (Dynamic Data Exchange) a communication protocol that let applications call each other.

OLE was the first protocol that enabled users and programmers to create compound documents?that is documents that contain data from different applications (for example an Excel worksheet inside a Word document).

With the help of Excel App instance. we can execute a Macro in VB code.

EXcelAppInstance.Application.Run("MacroName")

- When u build connection with database through coding, then its ADODB.When u build connection with database through ADO component, then its ADODC.

- ADODB is a ActiveXdll and ADODC is a ActiveXcontrol.

- No Need to bind with controls in ADODB whereas in ADODC we should bind with controls.

Tree view control is designed to display data that is hierarchical in nature, such as organization trees, the entries in an index, the files, directories on a disk. It is often used in conjuction with the List view control, which is used to display the contents of the folder selected in the tree view.

List view control displays data as listitem objects. The control excels at representing subsets of data or discrete objects.The list view property is often used in association with a tree view control.