vbs script or bat file

Status: Closed
Prize: $60
Entries Received: 3
Winner: Krish1019

Winner

Contest Brief

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)

Recommended Skills

Winner

Get Entries Like This

Employer Feedback

“supper quick ”

arggroup123, Australia.

Top entries from this contest

Krish1019 India

0
ranashahed2000 Bangladesh

0
sakhawat2 Bangladesh

0

Public Clarification Board

blui88
- 11 months ago
Hi,
I got little late.
Hope your work will be completed.
If an assistance required, in that case let me know.
Thanks
Santosh
- 11 months ago
Krish1019
- 11 months ago
Completed. Pls check Entry #1
- 11 months ago
sakhawat2
- 11 months ago
Are you expecting all jpg files? Will all the download links point to .jpg files?
- 11 months ago
1. Contest Holder
  - 11 months ago
  yes
  - 11 months ago
Contest Holder
- 11 months ago
the rows will go until j as in ten cells i will try to send some test data thru
- 11 months ago
1. blui88
  - 11 months ago
  Thanks for prompt response and sharing excel sheet.
  - 11 months ago
blui88
- 11 months ago
Hi,
I am interested in your project.
Can you please share some sought of excel file with dummy data & urls.
And do we need to get data from one sheet only, length of rows in that sheet.
If you like you may ping me.
Regards
Santosh
- 11 months ago
1. Contest Holder
  - 11 months ago
  i have just uploaded some test data
  - 11 months ago
Contest Holder
- 11 months ago
yes only on one sheet
- 11 months ago
Contest Holder
- 11 months ago
i have just up loaded a test file
- 11 months ago