UPS Tracking ETA Date in Excel

aschroeger
aschroeger used Ask the Experts™
on
Hello.

I have a user who has an excel spreadsheet containing hundreds of UPS tracking numbers.  The user would like to have the cell next to the tracking number pull in the delivery date (ETA date) of the tracking number.

I know I can hyperlink the tracking number to UPS's tracking site, but I would like help pulling in just the date of delivery into a new cell in excel.  Is this possible?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hmmm,  seems like it could be done.  Any chance we'd be able to access an RSS feed or something like that?

Is there a specific format to the web pages for tracking numbers that we could copy and then pull a specific item off the web page?  

Likely fairly complex, but could be done.

I'd start with something like this:

http://effectivemsofficesolutions.com/VBA/VBAWebScraping.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial