Retrieve variable from website

K

kidkosmo

Hi, Gang,

I'm hoping someone could provide me with the magic answer I seek. I
have a large list of FedEx tracking numbers loaded into a database. I
would like to be able to retrieve the delivery date from the FedEx
website for each of these numbers through automation. I've got things
down to navigating to the website with the proper post data in the
url, but I'm having a dickens of a time trying to retrieve the value.
The value is stored in a variable within a script on the page. How
can I get the value for the "var deliveryDateTime"?

Thanks. A segment of my VB and the page's script containing the
variable is posted below (I removed a large segment for space).

VB
strPath = "http://www.fedex.com/Tracking"
strPost = "?
clienttype=dotcom&track=y&ascend_header=1&cntry_code=us&language=english&mi=n&tracknumbers="
& rs!TrackingNumber &
"&action=1&language=null&cntry_code=null&clienttype=null"

strNav = strPath & strPost
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate strNav
ie.Visible = True

Do Until ie.ReadyState = 4
Loop

ie.Quit

Website script:
<SCRIPT CHARSET="utf-8">
var pickupDate = "";
var shipDate = "Dec 5, 2011";
var estimatedDeliveryDate = "";
var deliveryDateTime = "Dec 6, 2011 9:22 AM";
var templateType = "";
var selectedTimeZone = "";
var selectedGMTtime = "";
var selectedGMTtext = "";
var selectedTimetext = "";
var termsChecked = "false";
var showSplitShipScans = "no";
var trackBy = "by";
</SCRIPT>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top