What is VBA?

VBA is the acronym for Visual Basic for Applications.

An abbreviation for Visual Basic for Applications

Official name is "Visual Basic Applications Edition."

VBA is Microsoft's common application programming (macro) language for Word, Excel, Access, etc

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft

VISUAL BASIC APPLICATION = is the combination of VISUAL + BASIC for appliation

VISUAL = represents to procedure we adopt to develop user interface by using Boxes,dialogue boxes, controls etc

Basic = referes to programming code

There is no UNDO for macro actions

Loops and IF statement is heart to VBA

This macros exists for Excel,Word,Access

What are the advantages of VBA?

Through the process of VBA we can automate repetetive actions

We can generate reports in regular intervels without manual intervention

We can connect various databases through the process of VBA

We can automate Word documents and Power point presentations

What is the differnce between VBA and VB

VBA and VB having resemble in most areas but both are different

Macro Security

Following four, denotes about macro security

1) Disable all macros without notification

2) Disable all macros with notification

3) Disable all macros except digitially signed macros

4) Enable all macros

State about digital signature

Digital signature doesn't allow others

Macros assigned digital signature will open only in the systems having digital signature