Answer :
Compiling the component, running REGSVR32 MyDLL.dll
Answer :
All variables must be declared before use. Their type is not required.
Pascal programming Interview QuestionsAnswer :
Dim obj as OBJ.CLASS
Set obj = New OBJ.CLASS
or
Set obj = CreateObject (“OBJ.CLASS”)Answer :
Forward Only: Fastest, can only move forward in recordset.
Static: Can move to any record in the recordset. Data is static and never changes.
KeySet: Changes are detectable, records that are deleted by other users are unavailable, and records created by other users are not detected
Dynamic: All changes are visible. Pascal programming TutorialAnswer :
LockPessimistic: Locks the row once after any edits occur.
LockOptimistic: Locks the row only when Update is called.
LockBatchOptimistic: Allows Batch Updates.
LockReadOnly: Read only. Can not alter the data. MS Access Interview Questions Answer :
Connection: Used to make a connection between your app and an external data source, ie, sql server
Command: Used to build queries, including user-specific parameters, to access records from a data source
Recordset: Used to access records returned from an SQL query. With a recordset, you can navigate returned records. You can also add, modify or delete records.Answer :
shape, line controls
MS Access Tutorial VB.NET Interview Questions Answer :
Cancel
Answer :
Object linking and embedding, for using to other object classes like word, excel , autocad objects in our own applications, only thing we have to add reference for these objects.
VBA For Excel Interview Questions Answer :
Checkbox, comna, combo, list, picture, ADo control, Data,Datagrid, Datareport,Dir list biox, filelistbox etc.
VB.NET Tutorial Answer :
Early binding allows developers to interact with the object’s properties and methods during coding permits the compiler to check your code. Errors are caught at compile time. Early binding also results in faster code
Eg : Dim ex as new Excel.ApplicationLate binding on the other hand permits defining generic objects which may be bound to different objectsyou could declare myControl as Control without knowing which control you will encounter. You could then query the Controls collection and determine which control you are working on using the TypeOf method and branch to the section of your code that provides for that type
Eg : Dim ex as Objectset ex =CreateObject(“Excel.Application”)
ASP.NET Interview Questions Answer :
AppActivate (”C:windowssystem32cmd.exe”) ‘ Appilcation caption
SendKeys (”SA”) ’For sending one string
SendKeys “% ep”, 1 ’ For sending Clipboard data to Dos Pascal programming Interview QuestionsAnswer :
Private Sub Command1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 2 Then
PopupMenu Menuname
End If
End Sub VBA For Excel Tutorial Answer :
Option Base is to set the Index of the Array to start from 0 or 1.Like option explicit.. declare “Option base 1″ at the top. now the array will start from Index By default the index starts from 0.
Answer :
Clipboard.SetData and Clipboard.GetData
Fox Pro Interview Questions Answer :
getrows
ASP.NET Tutorial Answer :
Caption
Tableau Interview Questions Answer :
Alignment property, Tab Index etc
MS Access Interview Questions Answer :
In-process component is implemented as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries
Tableau Tutorial Answer :
The Parameters collection.
VB Script Interview Questions Answer :
Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows programmatically sort, merge, and format tables containing strings and pictures. DBgrid is A spreadsheet-like bound control that displays a series of rows and columns representing records and fields from a ADO Recordset object.
Answer :
Standard EXE, ActiveX EXE, ActiveX DLL, ActiveX document, and ActiveX Control.
VB Script Tutorial Answer :
Intrinsic controls - Default controls of VB6, These control are always available in VB6 Toolbox.
ActiveX controls - .These are extra controls which can be added into toolbox and this control having separate files (.ocx). Must be deployed separately along with application in other system.
Advanced C# Interview Questions Answer :
An in-process component is implemented as a DLL called ActiveX DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. Each client app that uses the component starts a new instance of it.
An out of process component is implemented as an EXE called ActiveX EXE, and unlike a dll, runs in its own process space. As a result, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients.
VB.NET Interview Questions Answer :
The sizing behavior of the image control differs from that of the picture box. It has a Stretch property while the picture box has an AutoSize property. Also picture box is a container control and support most of the graphics method.
Answer :
Function always return a value, wheras am method may or may not return value.
Visual Source Safe Interview Questions Answer :
Connect property
VBA For Excel Interview Questions Answer :
a) Table-type Recordset - Hold records from single table and can add, edit and delete.
b) Dynaset-type Recordset - Can hold editable records from multiple tables.
c) Snapshot-type Recordset - Hold read only records from multiple tables,
d) Forward-only-type Recordset - Hold read only records from multiple tables without cursor.
e) Dynamic-type Recordset -Holds editable records from multiple tables and changes done by other user also visible.Answer :
Both are display list of items, however in combo box user can edit the item.
Answer :
A modal form has exclusive focus in that application until it is dismissed. Moduless form are not required exclusive focus and it is default when we show any form.
Answer :
Class is template from we can create objects, Objects are instantiate of a class. For example car is a class and Maruti 800, Maruti Zen are objects of car class.
Answer :
Processes communicate with one another through messages, using Microsoft’s Remote Procedure Call (RPC) technology to pass information to one another.
Answer :
Query unload event occurs in a first and then unload event occurs, in MDI form we can trac child form closing status by using this event.
ASP.NET Interview Questions Answer :
a) LockPessimistic - Locks the row once after any edits occur.
b) LockOptimistic - Locks the row only when Update is called.
c) LockBatchOptimistic - Allows Batch Updates.
d) LockReadOnly - Read only. Cannot alter the data.Answer :
a) Connection
b) Command
c) Recordset
d) FieldAnswer :
Let used to set value for ordinary variable and Set used to set value for object variable.
Fox Pro Interview Questions Answer :
a) ByRef -pass the address of variable not value
b) ByVal - pass the valueAnswer :
Automatically redraw the outputs.
Answer :
DoEvents command tell program control to execute other commands, while executing long task.
Answer :
16 bytes
Tableau Interview Questions
Visual Basic - 467 Visual Basic interview questions and 723 answers by expert members with experience in Visual Basic subject. Discuss each question in detail for better understanding and in-depth knowledge of Visual Basic. When answering interview questions, be brief and succinct and try not to ramble. Below is a link to sample PBI questions and description of levels. We've provided descriptions of these different tools to help you prepare for your interview. PBI Questions -Microsoft Excel Version. PBI Questions- Microsoft Word Version. Description of Levels.
Answer :
Microsoft holds license for Visual basic applications and it has been developing that language. Visual basic applications have an embedded programming environment which assists programmers in developing custom solutions by using almost all features of visual basic. Applications which are currently hosting visual basic can fully utilize the power of Visual basic applications because they have an added functionality and ease of visual basic applications.
Answer :
- Visual basic is useful if you are planning to develop your programs from scratch. This language helps you in developing Active x controls, exe files, etc.
- Visual script is a powerful tool, through which you can create small scale applications on web pages, automation applications, etc. Integrated development environment is not present for VB script.
- Visual basic applications are very useful in automating your existing application. VB application is useful for developing already existing applications.
Microsoft Excel Interview QuestionsAnswer :
Most of the visual basic applications are available on 32 bit Intel platforms. These applications also run on many of the windows software systems such as server 2003, XP, Vista, etc.
Answer :
COM add-ins are software program's which are integrated into an application and they add already built in features to an existing application. They have common architecture across multiple applications which help in deploying applications much faster across varied applications. Microsoft 2007 supports various COM add-INS.
VBA For Excel TutorialAnswer :
Microsoft office 2007 supports Visual basic and has support with many various features. With MS office 2007 you can use desktop applications for creating tailored business solutions. These desktop applications can be used directly as construction sites.
Microsoft Word Interview Questions Answer :
Microsoft Visual basic has its host of problems one such being macros, Macros can be created which can create a havoc for a programmer with good intentions. Also the security issue rests in the hands of the user and not the programmer as such. A user can manipulate the VBA document.
Answer :
Line explicit function makes the compiler to identify all the variables which are not specified by the dim statement. This command significantly reduces the problem of type errors. This is used extensively because VBA deals with information rich applications in which type errors are common.
Microsoft Excel Tutorial Microsoft Powerpoint Interview Questions Answer :
The reasons which made Microsoft drop its support to VBA are as follows, Microsoft visual basic relies heavily on machine code which was written for Power PC architecture. Also it would take another two years for developing VBA support for its architecture. It also states that Microsoft will incorporate VBA in the next script of office release for Mac.
Answer :
Format functions can be used to format many of the expressions such as currency, time, date, percentages and numbers. These functions are much simpler to use in VBA. User defined date, numeric and string formats are present in many of the applications.
Microsoft Entity Framework Interview Questions Answer :
A computer registry can be used to store configuration settings and application initialization. We can use Getsetting function to read registry settings and save settings function to write registry settings. Application name, section, key, setting, and default are to be specified for registry modifying. It is advisable to know about your computer settings before modifying registry settings.
Microsoft Word Tutorial Answer :
Userforms should be used for complex user input. When an application input has non text as an input it is advisable to use Userforms rather than the input boxes. When you are using Userforms a user can give input any number of times which is not the case when you use input boxes. This can be accessible from the insert menu in your VBA editor after which you can insert your code.
Microsoft Azure Interview Questions Answer :
Visual basic applications have very rich and flexible applications but there is one limitation when using pointer function. Windows API has limited support for function pointers because it has the ability to use but not the functional support to call back the function. But later versions have support for modules. Function pointers have inbuilt support (DLL's) for call but not for call back.
Microsoft Excel Interview QuestionsAnswer :
Visual basic can be used within almost all Microsoft products such as Map point, Visio, Auto cad, Word perfect, ArcGIS, word, excel, etc. With VBA you can control many functions such as host application, menus, toolbars, user interface, import and export of files, data transfer and extraction from multiple interfaces.
Microsoft Powerpoint Tutorial Answer :
The chief use of VBA is to make use of its special function which helps in repeated actions. Goal seek function helps to reduce manual entry of the code each and every time. This solves the problem of repeated function entry by automating functions and actions. Sub routines are inserted into the using the VBA editor and command insert module.
Answer :
Data validation is an important concept in VBA. Application procedure and a custom dialog box can be used to correct input errors. You can assign an application procedure to the frame of a dialog box. Error message or custom dialog box can be highlighted with the first field with errors.
Microsoft Project Interview Questions Answer :
Shell command present in VBA can be used to start the dialer present in windows operating system. Phone number can be used to connect to your modem. With the use of shell and sendkeys you can dial to your user. Shell starts windows application and sendkeys inform the window to dial according to the keystrokes of the application. A macro can be used to start the cardfile program which activates the auto dialer feature.
Microsoft Entity Framework Tutorial Answer :
- ByRef: If you pass an argument by reference when calling a procedure the procedure access to the actual variable in memory. As a result the variable's value can be changed by the procedure.
- ByVal: If you pass an argument by value when calling a procedure the variable's value can be changed with in the procedure only outside the actual value of the variable is retained.
- ByRef is default: Passing by reference is the default in VBA. If you do not explicitly specify to pass an argument by value VBA will pass it by reference.
Excel Data Analysis Interview Questions Answer :
Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0.
Microsoft Word Interview Questions Answer :
- The Boolean data type has only two states, True and False. These types of variables are stored as 16-bit (2 Byte) numbers, and are usually used for flags.
- The Byte data type is an 8-bit variable which can store value from 0 to 255.
- The Double data type is a 64-bit floating point number used when high accuracy is needed.
- The Integer data type is a 16-bit number which can range from -32768 to 32767. Integers should be used when you are working with values that can not contain fractional numbers. In case, you're working over 32767 rows use Long as data type.
- The Long data type is a 32-bit number which can range from -2,147,483,648 to 2,147,483,647.
- The Single data type is a 32-bit number ranging from -3.402823e38 to -1.401298e-45 for negative values and from 1.401298e-45 to 3.402823e38 for positive values. When you need fractional numbers within this range, this is the data type to use.
- The String data type is usually used as a variable-length type of variable. A variable-length string can contain up to approximately 2 billion characters. Each character has a value ranging from 0 to 255 based on the ASCII character set.
Microsoft Azure Tutorial Answer :
ThisWorkbook refers to the workbook where code is being written while ActiveWorkbook refers to the workbook which is in active state with active window. In case of only one workbook open, ActiveWorkbook is same as ThisWorkbook.
Excel pivot tables Interview Questions Answer :
Last Row in a column can be find using End(xlUp) and Last Column in a row can be find using End(xlToLeft). For e.g. Range('A1048576').End(xlUp).Row gives last used row of Column A.
Answer :
- Forms controls can be used on worksheets and chart sheets. Forms controls can also be placed within embedded charts in Classic Excel (though not in Excel 2007). ActiveX controls can only be used on worksheets. ActiveX controls do not work in MacExcel.
- The Forms controls aren’t very complicated, and they have been part of Excel for longer (they were used in Excel 5/95’s dialog sheets) than the Controls Toolbox (Excel 97), so it stands to reason that they’d be more seamlessly integrated. Being newer, the ActiveX controls have richer formatting possibilities. Both can link to cells and ranges in the worksheet.
Microsoft Project Tutorial Answer :
- Subroutines never return a value but functions does return values.
- A function could not change the values of actual arguments whereas a subroutine could change them.
Excel Power View Interview Questions Answer :
Using Breakpoints(F9), Step-by-step execution (F8), Debug.Print & Immediate Window and Watch window.
Microsoft Powerpoint Interview Questions Answer :
Application --> Workbooks --> Worksheets --> Range / Chart.
Advanced Excel Charts Tutorial Answer :
There is a option 'Allow users to edit ranges' can be used for this purpose.
Microsoft Interview Questions Answer :
Using 'Data Validation'.
Microsoft Entity Framework Interview Questions Answer :
No one can't. They're fixed as 65536(2^16) in Excel 2003 or before and 1048576(2^20) in Excel 2007 & Excel 2010.
Advanced Excel Functions Tutorial Answer :
No one can't. They're fixed as 256(2^8) in Excel 2003 or before and 16384(2^14) in Excel 2007 & Excel 2010.
Answer :
We can create a workbook which cannot be modified but cannot create a workbook which can't be copied.(It depends on system security, it has nothing to do with Excel or VBA)
Answer :
Excel provides three ways to protect a workbook:
- Require a password to open the workbook.
- Prevent users from adding sheets, deleting sheets, hiding sheets, and unhiding sheets.
- Prevent users from changing the size or position of windows.
Excel Dashboards Tutorial Answer :
Use Application.Dialogs(xlDialogFont).Show or Application.Dialogs(xlDialogFormatFont).Show to load font dialog box from Excel VBA.
Answer :
ADO : ActiveX Data Objects is universal data access framework that encompasses the functionality of DAO.
ODBC : Open Database Connectivity(ODBC) is a windows technology that lets a database client application connect to a external database.
OLEDB : Low level programming interface designed to access a wide variety of data access Object Linking and Embedding (OLE). Microsoft Azure Interview Questions Answer :
Activesheet.PageSetup.PaperSize = xlPaperLetter (Similarly xlPaperA4 or xlPaperLegal etc.).
Answer :
Any of the three methods can be used:
- Create a class with the properties you require to return and then return the object of the class from the function.
- Using ByRef for the values.
- Return an array of the values.
Answer :
Yes because VBA is VB6.0 based which is an Object Based Programming Language and is also known as 'Event Driven Programming' and it supports Polymorphism, Encapsulation and partially Inheritance.
Microsoft Project Interview Questions Answer :
Set Cancel property of Button to True on the Form.
Answer :
Type libraries are files that explicitly describe some or all of the contents of components. This includes information about the methods properties constants and other members exposed by the component. Development tools such as Visual Basic make use of the information contained in the type library to help you as a developer access and use the component. In addition type libraries provide a convenient way to include a simple level of descriptive documentation for component members. You can use them through 'Tools --> References' in VBE.
Answer :
Volatile functions are a type of function that will always recalculate. That means whenever Excel needs to calculate any part of the worksheet, those cells containing volatile functions will also calculate.
Answer :
By adding Application.Volatile statement to it. It must be the first line of your User Defined Function.
Excel Data Analysis Interview Questions Answer :
Actually INDEX is not a volatile function, even though some MicroSoft documentation says it is. Anyway no its not possible to apply Application.Volatile(False) to a built-in Excel function except by duplicating what the built-in function does inside a UDF.
Answer :
- Dependency trees are excel way of minimizing the calculation by tracking what has changed since last calculation. It allows Excel to recalculate only:
- Formulae/Names that have changed.
- Formulae containing Volatile Functions.
- Formulae dependent on changed or volatile formulae or cells or names.
- Excel determines dependencies by looking at the cells referred to by each formula and by the argument list of each function.
- Dependency trees are immediately updated whenever a formula is entered or changed.
- To force the dependency trees to be rebuilt and all formulae calculation use CTRL+ALT+SHIFT+F9.
Excel pivot tables Interview Questions Answer :
using the Application.CalculationState property which tells if calculation has completed ( xlDone ), is pending ( xlPending) , or is in process ( xlCalculating ).
Answer :
There are two limits to the number of dependencies that Excel versions prior to Excel 2007 can track before it must do full calculations instead of recalculations.
- The number of different areas in a sheet that may have dependencies is limited to 65,536.
- The number of cells that may depend on a single area is limited to 8K.
After the workbook has passed these limits, Excel no longer attempts to recalculate only changed cells. Instead, it recalculates all cells at each calculation.
Answer :
VBA is licensed to Microsoft and this compatible with and only Microsoft products. Code written is compiled by an intermediate language called P-code and this is stored in hosting applications such as Excel, Word and Access. The intermediate code is interpreted by a virtual machine. This code and intermediate language is the exclusive right of Microsoft.
Answer :
- The current region is a range bounded by any combination of blank rows and blank columns.
- This property is useful for many operations that automatically expand the selection to include the entire current region, such as the AutoFormat method. This property cannot be used on a protected worksheet.
- The UsedRange property is used to select the range of used cells on a worksheet. It returns a Range object that represents the used range on the specified worksheet.
- Every non-blank cell got its CurrentRegion and its keyboard shortcut is Ctrl+Shift+Spacebar.
- There can be many current regions but there is only one used range in a worksheet.
Answer :
XLM (used in Excel 97 or before) and VBA(used for 2000 and after). Obviously, VBA is in use these days.
Answer :
The area under which the container provides the view of the ActiveX Document is known as a view port.
Answer :
The Variant data type has a numeric storage size of 16 bytes and can contain data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length),and can store any character text.
Answer :
Syntax Errors, Runtime , Logic.
Answer :
Yes.
Answer :
Predefined, Custom, User Defined.
Answer :
Public, private, Friend.
Answer :
Set Value is assigned to ActiveX Object from the form. Let Value is retried to ActiveX Object from the form. Get- Assigns the value of an expression to a variable or property.
Answer :
Field, Form.
Answer :
Messaging Application programming Interface.
Answer :
Simple Single Select , Extended, Multiple Select.
Answer :
DCOMCONFIG.EXE.
Answer :
The Controls which do not have Align property can't be placed on MDI Form.
Answer :
Vbrun300.dll.
Answer :
The Parameters collection.
Answer :
Database Pooling, Transactional operations, Deployment, Security, Remote Execution.