Assignment #8
(20 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 "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".
Supporting files can be downloaded from the
Assignment #8 folder.
PowerShell Code 1:
PowerShell Code 2:
VBA Code:
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.
|