Intro to MS Office Macros & VBA

People who are cybersecurity specialists need to understand that the "bad guys" look for vulnerabilities and then create scripts or programs that can maliciously act upon those vulnerabilities. This is true for operating systems, system software, physical hardware, etc. Over the years, Microsoft has had quite the tussle with "bad guys" creating malicious Excel macros and then getting users to download them and run the macros. So, by default, everything is shut off, macro- and VBA-wise. VBA is "Visual Basic for Applications" and allows programmers to write code for MS Office using Visual Basic (VB). It's a powerful feature and the "bad guys" know about it! You need to know about it too!! 00:00 Introduction 01:30 Intro 03:05 Enabling Macros 04:58 Creating an Excel Macro 11:04 Running Your Macro 12:01 Writing VBA Code 15:12 Relative vs Absolute Cell References 16:54 Invoking the VBA Editor 17:49 Saving the Workbook as a Macro-Based Workbook 21:11 Writing VBA Code 27:24 Running Your VBA Code 30:20 Do Other Office Automation Apps Support VBA? 31:51 Outro