This workshop covers the basics of automating excel with macros using Visual Basic for Applications (VBA). This course will utilize Excel but the knowledge can easily transfer to other programs that have VBA capabilities. This course will focus on the thought process behind creating macros more than the syntax of the programming language.
Topics include:
- What macros are
- VBA and the Visual Basic Editor
- Recording macros
- Programming basics
- Saving macros and add-ins
Note: This class is taught using Excel for Windows. The Excel features used in this course are not available in the Mac version of Excel.