Скачать или смотреть 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