Sawaal
  • Home/
  • Searching for %

 Searching for "%"

Q:

Explain about creating VB applications in excel ?

Answer

User defined functions can be created into the Microsoft spreadsheet. Spreadsheets can be customized according to the user needs by using VB applications. To create visual basic functions useful for spreadsheet you need to click Tools and select Macros where you will need to click on Visual basic editor.

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

What are the rules which should be followed while naming a variable in VB?

Answer

Some of the rules which should be followed while naming a variable in VB are as follows: 


1) Characters should be less than 255.


2) Space between characters should be allowed.


3) A variable should begin with a number.


4) Period may not be permitted.

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

Difference between ActiveX Exe and Dll ?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

How can visual basic be used for server side scripting?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

What are the different ways to Declare and Instantiate an object in Visual Basic 6?

Answer

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 

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

What is the difference between dao,rdo and ado explain simply ?

Answer

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 

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

Difference between DDE and OLE?

Answer

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).

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview

Q:

Can I call an XLM macro from within Excel VB?

Answer

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


EXcelAppInstance.Application.Run("MacroName")

Report Error

View answer Workspace Report Error Discuss

Subject: Microsoft Interview