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>
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>