vba usps api
1 TopicUse VBA to track parcels from USPS API
Does anyone have a module to get status and info for parcels from USPS API ? I have created the code below, but I don't know how to get the right response : Dim html As HTMLDocument, dateString As String Set html = New HTMLDocument With CreateObject("MSXML2.XMLHTTP") .Open "GET", "http://secure.shippingapis.com/ShippingAPI.dll?API=TrackV2&XML=<TrackRequest USERID=" & "988HONES7813" & "><TrackID ID=" & id & "></TrackID></TrackRequest>" .send GetRESPONSE = .responseTextSolved2.4KViews0likes4Comments
