+ Reply to Thread
Results 1 to 5 of 5

Use VBA to enter tracking number into website and submit form

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Use VBA to enter tracking number into website and submit form

    Hi,

    I am trying to automate the tracking of my shipping containers into an excel spreadsheet.

    I currently use the following link to do this. https://www.shipmentlink.com/servlet...rgoTracking.do

    The problem is that I cannot figure out how to get VBA to enter my shipping tracking number and return the information I require.

    I can get VBA to open the website but I need to enter a unique code and submit the form.

    Thanks in advance

    Shet

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Use VBA to enter tracking number into website and submit form

    It is difficult to say if it is possible with out looking at the page since it requires a real tracking number. Is the tracking number a secure number and do you need to login to access the info? If the answer is yes, you are left on own since noone but account holder can see the view page.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Use VBA to enter tracking number into website and submit form

    Give his a go:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Registered User
    Join Date
    11-12-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Use VBA to enter tracking number into website and submit form

    You Sir are a master. Thank you. It worked perfectly.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Use VBA to enter tracking number into website and submit form

    Wonderful, I'm glad it worked out. Could I ask you to mark the thread as solved when you have a moment? Thanks in advance

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using VBA to enter data into a Javascript form and submit on website
    By JulesHill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2016, 04:03 PM
  2. submit to website after file is created
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2014, 09:15 PM
  3. enter number in cell, website is searched.
    By david meyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2014, 12:45 PM
  4. VBA code to select dropdown value from a website form and submit
    By prabs_message in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:34 AM
  5. Help: Submit form to website (PHP System) and retrieve response in Excel
    By AMRayner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 10:53 AM
  6. Replies: 1
    Last Post: 02-05-2012, 09:31 PM
  7. Trying to submit a filename to a website form for upload.
    By mctabish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2010, 11:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1