Looking up Fedex Tracking arrival date

[Chrisd260]

I am trying to create a VBA program in which one of the sub-procedures sends a single tracking ID to FedEx's website and then retrieves the estimated arrival date. I can get the VBA program to open FedEx's webpage showing the tracking information, but by using the data connections I cannot get the excel sheet to download the data. Any ideas on how to do this? I would be willing to use either the data connections method or by VBA code.

Oh, and I work for a company that will NOT use any software unless it's code can be reviewed (line by line) by the IT department, so I cannot use one of the add-ons that I have seen for sale.


Thanks so much for your help!

 

[hippiehacker]

once the site has been opened with tracking number import the site to excel via web query and read the information out (if possible)

 

[Steve Works]

I think package tracking is an available tool now.
_________________________________________
Steve Works
W2C customs brokers

 

[Chrisd260]

I think package tracking is an available tool now.
_________________________________________
Steve Works
W2C customs brokers

Thanks for the update!