vbs script or bat file
- Status: Closed
- Prize: $60
- Entries Received: 3
- Winner: Krish1019
i need a vbs script to read an excel sheet.
step 1 create a folder with the name from cell a2 (if folder exists add to it with step 2)
step 2 create a sub folder in the folder from step 1 with the name from cell b2 (if folder exists add to it with step 3)
step 3 download a file from the url in cell d2 place the file in the folder from step2 and rename the file with the name from cell c2.
step 4 repeat step3 for cells e2 to j2 (cell e2 file name f2 file url and so no) if the cell is empty continue on.
this will need to be completed for all rows in the sheet (until column a is empty)
“supper quick ”