vbs script or bat file

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

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

Employer Feedback

“supper quick ”

Profile image arggroup123, Australia.

Top entries from this contest

View More Entries

Public Clarification Board

  • blui88
    blui88
    • 1 month ago

    Hi,
    I got little late.
    Hope your work will be completed.
    If an assistance required, in that case let me know.
    Thanks
    Santosh

    • 1 month ago
  • Krish1019
    Krish1019
    • 1 month ago

    Completed. Pls check Entry #1

    • 1 month ago
  • sakhawat2
    sakhawat2
    • 1 month ago

    Are you expecting all jpg files? Will all the download links point to .jpg files?

    • 1 month ago
    1. arggroup123
      Contest Holder
      • 1 month ago

      yes

      • 1 month ago
  • arggroup123
    Contest Holder
    • 1 month ago

    the rows will go until j as in ten cells i will try to send some test data thru

    • 1 month ago
    1. blui88
      blui88
      • 1 month ago

      Thanks for prompt response and sharing excel sheet.

      • 1 month ago
  • blui88
    blui88
    • 1 month 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

    • 1 month ago
    1. arggroup123
      Contest Holder
      • 1 month ago

      i have just uploaded some test data

      • 1 month ago
  • arggroup123
    Contest Holder
    • 1 month ago

    yes only on one sheet

    • 1 month ago
  • arggroup123
    Contest Holder
    • 1 month ago

    i have just up loaded a test file

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!