Excel VBA Training Using PVD402 Demo Code
Private Training Program for Use by Coalmont Magazine Editors
A | Prerequisites
Do the following to get started:
- Use a 64-Bit Windows computer
- Download and install Google Chrome
- Download and install Firefox as the default browser
- Use Excel 2016
- Download and install the Rubberduck add-in tool for use with the Visual Basic Editor in Excel 2016. For more information, see Rubberduck Add-in Tool for Visual Basic Editor in Excel
- Ask for the account and password of the test email as provided by Chuck Day.
- Download the Excel file pvd402aaQ.xlsm from this folder here on GitHub. The following image shows the file location.
B | Disable Security Warning
 This is not urgent. When you have time, do as instructed below to disable the red-circled Microsoft Excel Security Notice in Office 2016.
 A warning will often appear in Microsoft Office 2016 applications such as Excel if you include a hyperlink to an EXE or other type of file that could be harmful to your system. While coding, you may want to disable this feature. | Tell me how
 Follow the steps as presented on this page here or on this page here. The instruction may not be 100% correct. The node “Policies” may not be involved at all. Read the next two paragraphs first, before you make your first attempt at the Windows Registry Editor. The next image shows an actual experience. Notice that Policies is not in the highlighted path at the top of the image.
 The following image shows the result of a test. When you run the first demo, two different browser tabs should appear without delay due to an Excel Security Notice.
 To do the above programmatically, use the following code:
Dim oldValue As Boolean
oldValue = Application.ScreenUpdating
Application.ScreenUpdating = False
Shell “reg add “”HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Security”” /f /v “”DisableHyperlinkWarning”” /t REG_DWORD /d 1 /reg:32"
Application.ScreenUpdating = oldValue
C | Run the Three Demo’s
 After you open the Excel training file pvd402aaQ.xlsm, or a later version, click on the button Dashboard 402 to bring up the dashboard. On the dashboard, click on the dropdown button then select the first demo option, “1 — Trace Log Demo”. Press the Go button to see the selected demo. Press the button “Tell me more” to read about the demo.
 Do the same and view the second demo: “2 — Automation Demo”. Again, press the Go button to see the selected demo. Press the button “Tell me more” to read about the demo.
 Do the same and view the third demo: “3 — Web Scraping Demo”. Again, press the Go button to see the selected demo. Press the button “Tell me more” to read about the demo.
D | What to Learn?
 Here are the learning objective. Do whatever it takes such that you can explain how to code works in each demo.
- How does the code work in the first demo?
- How does the code work in the second demo?
- How does the code work in the third demo?
 You’re NOT expected to answer the above questions by yourself. You’re expected to carry out a long, slow conversation with the code creator and learn how to work with each line of code in the demo. Help will be provided along your journey into the world of programming.