Create a new file titled Lecture$07$File.xIsm inside a folder called Lecture$07$

Create a sub in the file Lecture$07$File.xlsm to open a file names Sample$1.$xlsx in

the same folder. Make sure that the folder has the excel sheet titled Sample$1.$xlsx

Path of the file name should not be hard coded. You MUST use

Application.ActiveWorkbook.Path

Create a new sub in the file Lecture$07$File.xlsm to select column $C$ in the sheet$1$

of the Sample$1.$xlsx file and clear contents in the column $c.$

Deliverable: Submit Lecture$07$File.xIsm