Excel Webservice

[Swi]

Hi,

I am using the following code to return a web service API call from the USPS.

=FILTERXML(WEBSERVICE("http://production.shippingapis.com/ShippingAPI.dll?API=TrackV2&XML=%3CTrackRequest%20USERID=%22"&$E$1&"%22%3E%3CTrackID%20ID=%22"&D3& "%22%3E%3C/TrackID%3E%3C/TrackRequest%3E"),"/TrackResponse/TrackInfo/TrackSummary[1]")

However, when I publish/save to OneDrive as a shared document if you edit the cell and hit enter to update it for any reason you get a #VALUE! in the cell.

Any ideas or is this a limitation of a shared Excel document online.

 

[dhookom]

Do you get the same result when using locally? Does other functionality work when using OneDrive?

 

[mintjulep]

See this:

ActiveWorkbook.SaveAs when the template is on OneDrive - VBA Visual Basic for Applications (Microsoft)

I have a simple macro enabled excel template (.xltm) that prompts for a file name and saves the file in the desired location when a new file is created. Sub SetMyName() Dim FileName As String Dim MyPath As String If Sheets("Expense Report").Range("J41").Value = 0 Then 'only if no paid...

www.tek-tips.com