Assignment #8
(20 points)
- Watch the video
Task Automation.
- 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 "assignment8". Then convince me that your code works
by testing it on a few files. You can either test the VBA code or the
Powershell code or both.
- Option B:
- Write out all the VBA and Powershell code presented in this video.
Briefly comment what each line does. Save your work as
"assignment8".
PowerShell code:
Note: MS Excel and (I believe PowerShell) is 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.
|