Excel VBA Training Using PVD402 Demo Code

Private Training Program for Use by Coalmont Magazine Editors

Nickantony Quach
Jan 28 · 3 min read

Coalmont VBA | Edit | Contact us

A | Prerequisites

Do the following to get started:

  1. Use a 64-Bit Windows computer
  2. Download and install Google Chrome
  3. Download and install Firefox as the default browser
  4. Use Excel 2016
  5. 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
  6. Ask for the account and password of the test email as provided by Chuck Day.
  7. Download the Excel file pvd402aaQ.xlsm from this folder here on GitHub. The following image shows the file location.

B | Disable Security Warning

[2] This is not urgent. When you have time, do as instructed below to disable the red-circled Microsoft Excel Security Notice in Office 2016.

[3] 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

[4] 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.

[5] 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.

[6] To do the above programmatically, use the following code:

Sub DisableHyperlinkWarning()

Dim oldValue As Boolean
oldValue = Application.ScreenUpdating
Application.ScreenUpdating = False

https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/reg-add
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

End Sub

C | Run the Three Demo’s

[6] 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.

[7] 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.

[8] 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?

[9] 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?

[10] 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.

CoalMont

Our offense on a great Black Mountain

Nickantony Quach

Written by

Founder of Ri4CTV, a channel on YouTube, Creator of Thumoslang, the nomenclature for social life, and Father of One, who works for the NFL

CoalMont

CoalMont

Our offense on a great Black Mountain

More From Medium

More on Pvd402 from CoalMont

More on Pvd402 from CoalMont

More on Pvd402 from CoalMont

GdriveTest101

More on Pvd402 from CoalMont

More on Pvd402 from CoalMont

Google Drive API First Attempts

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade