Comprehensive VBA-Part 01 Intro

This is the intro to a comprehensive course on programming Microsoft Office. More specifically, VBA or Visual Basic for Applications. VBA can control and therefore automate the Microsoft Office family, including • Word, • Excel, • PowerPoint, • Access, • Outlook, • InfoPath, • OneNote, • and Publisher. This course is designed with 2 primary objectives: 1. practical real-world programming Microsoft Office with VBA. There will be lots of examples as well as a thorough study of the VBA language. Examples will come before theoretical study. 2. introduce programming. VBA is the easiest language to learn. Programming concepts will be subtly introduced and in the context of real problems. this course will cover: • Programming Microsoft Office Word, Excel, PowerPoint, Access, and Outlook. • Controlling Microsoft Office OneNote, Publisher, and InfoPath. • Program to program collaboration such as Microsoft Word exchanging data and controlling Microsoft Excel. • functions -- including string and math • dates and times control statements -- such as if, for, and do • objects and their properties -- for keeping related data together -- such as a an Excel workbook's worksheets and charts. • Collections -- collections are objects of a common type -- such as the Worksheets in an Excel workbook or the Paragraphs in a Word document. • reading files and directories on your hard drive • regular expressions -- which is the most powerful find and replace command