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