| Name |
Description |
| Automation |
Automation makes
it possible to reduce time on many office tasks
by 50% or more. Automation is simply the ability
to operate or control an Office application, thus
reducing human intervention to a minimum. Everyday
tasks, jobs and workflows can be automated. The
power of the applications can be extended. No additional
software is required. |
| Control |
An element of a
userform or dialog box such as a button, drop down,
list box or text input box. Controls can be used
to enter data, display a list, open a file, etc.
Controls may also be added to a document page, similar
to a form field. |
| Form Field |
A data-entry field
on a document page. A user supplies information
in a field by typing text or selecting the field.
Form fields can be used to enter text, select items
from a list or to check items. |
| Macro |
A macro is a set
of commands which can complete a series of tasks.
It can do simple functions like inserting your name
and address into a document. Or it can perform complex
assignments such as copying data from one application
to another and then repeating this several times.
Tasks performed by macros are usually repetitive
in nature and provide significant time savings. |
| Office Security |
Office applications
are designed to give users control of their security.
As with all applications, such as running programs,
opening an executable, or accessing websites, there
can be malicious intent. Ensure you always stay
protected. Set your macro security appropriately.
Only run macros from known authors. Have real-time
virus protection installed. Use a Digital Certificate
to automatically run macros without changing the
security. |
| Query |
The process by
which data are retrieved from a database in order
to gain information from it. |
| Source Code |
A collection of
statements or declarations written in Visual Basic
for Applications. Source code allows the programmer
to communicate with an application using human instructions. |
| Template |
Templates are a
special type of Word or Excel file. Templates will
create a new document or workbook when opened. A
template may be a form, or can contain a macro program,
or store document styles. Templates enable the user
to bypass the initial setup and configuration time
and create standard files. |
| Userform |
A custom dialog,
or graphical pop-up window that collects and processes
input from the user. Userforms look and act like
any of the familiar built-in dialogs, such as when
you click File–›Print or Format–›Font in Microsoft
Word. |
| Visual Basic for
Applications (VBA) |
A procedural programming language used to build
custom solutions for Microsoft Office applications.
It can control most aspects of an Office application,
including manipulating menus and toolbars, and working
with custom userforms or dialog boxes. VBA is closely
related to Visual Basic, but normally runs within
an Office application rather than as a standalone
program.
|
| VB Script |
VB Script (Visual
Basic Scripting Edition) is an Active Scripting
language for controlling Microsoft Office. The language's
syntax reflects is a limited version of Visual Basic
programming language. |
| Workflow |
A set of steps,
process or a procedure in which tasks are completed.
A business process may be automated according to
a set of rules defined by a particular workflow
scheme. |
| XML |
XML (Extensible
Markup Language) is a set of rules for encoding
documents electronically. It is compatible of a
variety of programming languages and platforms.
XML-based formats have become the default for most
office productivity tools. |
