VBA
Microsoft Office scripting
VBA stands for Visual Basic for Applications, a programming language built into Microsoft Office products.
It allows users to automate repetitive tasks and create custom functions in Excel, Word, Access, and other applications: I wrote a VBA macro to format the monthly reports automatically.
VBA code runs within the host application rather than as a standalone program.
Microsoft's data-crunching application
- spreadsheetTabular data organizer
- workbookEducational exercise manual
- worksheetExercise page for students
- cellsBasic biological units
ranges · formulas · pivot · chart · recording · automation · subroutine · module
Microsoft programming language, simplified
- codeSymbolic communication system
- syntaxRules for arranging words
- variablesChangeable elements in equations
- functionsWorks or serves purposes
subroutine · loop · conditional · array · object · class · module · procedure
Redmond technology corporation
- AccessMeans of approach
- OutlookMicrosoft email application
- PowerPointMicrosoft's presentation application
- automationSelf-operating system design
interop · document · email · presentation · database · query · report · form
Database manipulation language
- databaseOrganized digital information collection
- connectionA joining or relation
- queryRequest for information
- tableHorizontal furniture surface
import · export · CSV · XML · parsing · scraping · manipulation · transformation
Excel
Microsoft's data-crunching application
- spreadsheetTabular data organizer
- workbookEducational exercise manual
- worksheetExercise page for students
cells · ranges · formulas · pivot · chart · recording · automation · subroutine · module · events
Visual Basic
Microsoft programming language, simplified
- codeSymbolic communication system
- syntaxRules for arranging words
- variablesChangeable elements in equations
functions · subroutine · loop · conditional · array · object · class · module · procedure · debugging
Microsoft
Redmond technology corporation
- AccessMeans of approach
- OutlookMicrosoft email application
- PowerPointMicrosoft's presentation application
automation · interop · document · email · presentation · database · query · report · form · template
SQL
Database manipulation language
- databaseOrganized digital information collection
- connectionA joining or relation
- queryRequest for information
table · import · export · CSV · XML · parsing · scraping · manipulation · transformation · cleaning
- BASIC dialectsVisual Basic
- programmingvariables, functions, for, function, debugger
- Access DatabaseAccess, tables, queries, forms, reports
- scripting languagesJavaScript, Python, Perl, Ruby, PHP
- VBAmacro, sub, function, module, workbook
- macrosExcel macros, macro virus, task automation, action sequences, scripts
Control by human action
point-and-click · drag-and-drop · touch interface · voice commands