Assignment #32
(10 points)
- Watch the video
Task Automation
(CC).
- Complete either "Option A" or "Option B" below:
- Option A: (Preferred)
- Write out all the VBA and Powershell code presented in this video.
Save your work as "assignment32". Then convince me that your code works
by testing it on a few files. You can either test the Powershell code
or VBA code or both. You can download some test files from the
Assignment #32 folder.
- Option B:
- Write out all the VBA and Powershell code presented in this video.
Briefly comment what each line does. Save your work as
"assignment32".
Code used in this video:
Note: MS Excel and (I believe PowerShell) are installed on all NSU computers.
PowerShell is free software that can be installed on Windows, Linus, or MacOS.
- Upload your work (and any supporting files) to your YOUR-CLASS-WEBSITE.
Help.
|