When I run this code,
Sub OvrXML() Dim Chnger As Variant Chnger = Range("A1").Value ActiveWorkbook.XmlImport URL:= _ "https://www.prr.net/webapps/agguides.pgm?task=agentinfo&agent=" & Chnger _ , ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$5") End Sub
cells A5:G5 are populated with XML data -just a unique agency name (specified by the variable Chnger in the code), and some contact information. When I change cell A1 to, let's say, 1204, I would expect the the old XML data in A5:G5 to be overwritten by the new agent 1204 information. But instead i get the error
The operation could not be completed because the result would overlap an existing XML mapping.
What am I doing wrong here?
Thanks so much for any assistance.