TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Post an article
Translate this page
Powered by
Microsoft® Translator
Wikis - Page Details
First published by
Durval Ramos
When:
13 Mar 2014 1:28 PM
Last revision by
Ken Cenerelli
(MVP, Microsoft Community Contributor)
When:
5 Sep 2015 11:37 AM
Revisions:
15
Comments:
6
Options
Subscribe to Article (RSS)
Share this
Engage!
Wiki Ninjas Blog
(
Announcements
)
Wiki Ninjas on Twitter
TechNet Wiki Discussion Forum
Can You Improve This Article?
Positively!
Click Sign In to add the tip, solution, correction or comment that will help other users.
Report inappropriate content using
these instructions
.
Wiki
>
TechNet Articles
>
VBA & VBS Portal
VBA & VBS Portal
Article
History
VBA & VBS Portal
Table of Contents
Introduction
MS Office
SQL Server
Active Directory
Others
VBA-General
See Also
Other Languages
Introduction
Visual Basic for Applications (VBA) is a programming language which is used to control Microsoft Excel's functionality or any other program developed in Windows Operational System, since it's compatible with this Technology.
In the Microsoft Office products, you write these procedures in macros using Visual Basic Editor. These procedures are called modules and can be viewed by pressing
Alt+F11
.
VB Script (VBS) have the same context as the VBA, but in separate files with extension
.vbs
, and using methods and properties of Windows Script Host (WSH). You can access Windows API and other low-level functionality through dynamic-link libraries (DLLs).
This article is a list of all VBA and VBS articles in the
TechNet Wiki
. They can be found using the following tag search:
VBA
.
MS Office
Sending from a Selected Account in Microsoft Outlook
Deleting Outlook Temporary Files
Batch change of domain names in e-mail addresses
Outlook: how to use a script to create Distribution Lists from multiple e-mail addresses
Changing PDA's category from "Other" to "Main" in MS Outlook contacts
Outlook: macro to move messages to another folder with conditions
Saving images and attachments used in e-mail messages
Transferring and creating non-standard rules in MS Outlook
Searching Messages in Microsoft Outlook by their Subjects
How to Print Email without the Default Fields
How to Update Contacts in Distribution Lists
How to Use VBScript to Run a PowerShell Script
Creating Tasks and Appointments Based on Email Messages
Best Practices for Using the HPC Macros to Run Excel Workbooks on a Cluster
Windows HPC and Microsoft Excel: Resources for Building Cluster-Ready Workbooks
Merge Word 2010 Documents by Using Access 2010 VB
Mail Backup - Automatic Export to MSG Files
Searching Messages in Microsoft Outlook by their Subjects
Transferring and creating non-standard rules in MS Outlook
Sending from a Selected Account in Microsoft Outlook
How to Print Email without the Default Fields
Saving images and attachments used in e-mail messages
Password Box - A variant of Input Box
↑
Return to Top
SQL Server
Convert VBA Code to Transact-SQL
Custom MDX Query for Excel Filters
Query Power Pivot DMVs with VBA
Connect Microsoft Excel to Windows Azure SQL Database
Reading Windows Events and Inserting in SQL Server
↑
Return to Top
Active Directory
VBScript to Create Active Directory Security Groups
VBScript to Read and Update an Excel Spreadsheet with Computer Description from Active Directory
Step-by-Step Guide to Bulk Import and Export to Active Directory
Extract Members of an AD Group to Excel
Active Directory: LDAP Syntax Filters
Active Directory: Characters to Escape
How to Reset Secure Channel Remotely Using Script
Active Directory: Ambiguous Name Resolution
How to Read Computer Names from a Text File and then See if the Computers Still Exist
How to Determine Which Organizational Unit (OU) Must Be a User Account
↑
Return to Top
Others
VBScript: Map network drives on logon
VBScript - SendKeys Method
BizTalk: Monitoring and Automatically Starting Host Instances Via A Scheduled Task
Operations manager Agent fails to execute VB scripts - Logs event ID 21405
Create Random Passwords with Characters and Integers Using VBScript
Is RecordCount property is always returning -1 for your RecordSet Object?
DFSR Performance Objects, Their Counters, Corresponding WMI Classes, and Using WMIC or Vbscript to View Them
VBScript for Adding Network Printers at User Logon
VBScript: Determine Script Execution Time
Getting Information about a Variable in VBScript
How to Add GacUtil Refresh as a Context Menu Item in the Windows Shell - Gacutil
Hyper-V: How to Detect if a Computer is a VM Using Script
Hyper-V: Troubleshoot Pending Snapshot Merges
How to Generate Customized FIM 2010 CM Reports Automatically
How to Attach a Custom Task to an Event on Windows Server 2008
ConfigMgr (SCCM) How to Increase WMI Default Memory Allocation
VBScript to add multiple systems into a collection (SCCM)
Management Pack Service Model Exercise #6 - Creating a Script Discovery (VBScript)
ConfigMgr (SCCM) EXE files and RUN Commands
How to Generate Readable Alerts Based on SNMP Traps in MOM 2005
Script to Determine Status of Optional Features Using Win32_OptionalFeature WMI Class
SharePoint 2007: Write an IIS Warm Up Script for a SharePoint Intranet Site
Logon Script to help your child learn their multiplication tables!
Query Registry for bulk servers
Query a Registry Key for Bulk Computers
VBScript: Find out Who Owns Your Computers
↑
Return to Top
VBA-General
Get Setting Flags in Enumerations
See Also
Portal of TechNet Wiki Portals
↑
Return to Top
Other Languages
Portal VBA e VBS (pt-BR)
VBA & VBS Portal (nl-NL)
↑
Return to Top
This article was awarded the
silver medal
in the
TechNet Guru of March/2014