In Progress

Online Shipping Intereactive VBA Script in Excel - Web Scraping

This is a shipping script. It will need to be written with VBA in Excel. It will need to interact with online system to ship items listed in the spreadsheet. It must be verbosely documented.

Approximately 12 or so steps:

1. I need it to read shipping parameters from excel sheet and then go to shipping page with URL built from parameters

2. Once the page is loaded, it will check a box, and then click the "go" button.

3. On the next page it will check a box and enter in a quantity per case and number of cases (from parameters and logic) and click the "continue" button.

4. On the next page it will verify preferred shipment destination is available, and if needed go back to previous page and adjust quantities/cases and repeat unit the preferred destination is available. Once it finds the preferred destination option available, it will check the box next to it, and name it (from parameters), and click the continue button.

5. On the next page it will click the continue button.

6. On the next page it will verify the quantity is correct and adjust as necessary, and click on the continue button.

7. On the next page it will check the box next to the preferred carrier, and click on the continue button.

8. On the next page it will enter in the weight of the package (from parameters), and click on the continue button.

9. On the next page it check the box to authorize the shipment, and click on the continue button.

10. On the next page it will click the print button (which will initiate a download to be saved), and then the continue button.

11. On the next page it will click the “Shipped” button, and then the continue button.

12. On the next page it will click the print button (which will initiate a download to be saved), and record the shipment identification information displayed back into excel.

I will supply the source code for each of the pages. You will have to write the code without actually interacting with the pages. Once your code is ready for testing, I will test it and relay the results for corrections if needed.

For a seasoned scraper, this should be a relatively simple project. Do you have the skills? Would you like to tackle this project? Only looking for bids from those that can see the simplicity of this task, have the skills to accomplish it quickly, and do so with thorough documentation.

Best wishes,

Michael

Skills: Data Mining, Excel, Visual Basic, Web Scraping

See more: web scraping vba excel, excel web scraping, write your name online, write name on items online, web scraping with vba, visual basic 6.0 online, visual basic 5 online, vba spreadsheet scraping, spreadsheet script, pages to write on online, online visual basic 6, online test of visual basic, logic supply, code vba online, code check online, code 8 online, check code online, check c code online, best web scraping, write a script online, print vba, excel 2013 vba, visual c++ online, visual basic online, web scraping excel

About the Employer:
( 3 reviews ) Hilliard, United States

Project ID: #4351561

Awarded to:

srikartiram

Please check PMB

$80 USD in 5 days
(0 Reviews)
5.2

12 freelancers are bidding on average $151 for this job

mantislin

Hi sir, please check PM, thx Kimi.

$248 USD in 5 days
(77 Reviews)
6.2
ehsankayani

HI, I have a perfect profile for scrapping tools,Kindly see details in PMB Thank you

$180 USD in 3 days
(32 Reviews)
5.8
vbexcel

Excel/VBA web data extraction pro with over ten years of experience.

$190 USD in 3 days
(28 Reviews)
5.4
jitendraparmar07

Automation expert here. I can easily write such a bot/[url removed, login to view] check your PMB.

$200 USD in 3 days
(15 Reviews)
4.6
srdas2012

Hi,We are VBA/Macro Expert,Please see PMB

$200 USD in 7 days
(8 Reviews)
3.2
vivek90

Dear sir, I am a professional data entry worker & can complete this project with your requirements, please see my private message for details!! Regards,

$100 USD in 4 days
(3 Reviews)
0.5
shoaibalikhan

Its not much difficult task . Sir I can do it for you.

$30 USD in 3 days
(0 Reviews)
0.0
shakilsharif

Michael, Good day! Your job post caught my attention and I truly feel that I am the perfect match for the job. I am an experienced virtual personal assistant and I can offer my skills for your mentioned job features. More

$129 USD in 3 days
(0 Reviews)
0.0
dohko1911

I have understood your requirements and put a summary in separate post to you. Please read and communicate with me.

$170 USD in 5 days
(0 Reviews)
1.6
lalitparab

I Am well versed with excel would give 100%

$140 USD in 3 days
(0 Reviews)
0.0
sorin1970

I would like more details POSSIBLE TO START WORKING CODE.

$140 USD in 2 days
(0 Reviews)
0.0