Overwriting XML Data...

Hello, all!

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

Quote

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.

Re: Overwriting XML Data...

Hello again.

I changed the code to

Sub OvrWrtXML()


Dim Chnger As Variant
Chnger = Range("A1").Value


Rows(4).Delete


    ActiveWorkbook.XmlImport URL:= _
        "https://www.prr.net/webapps/agguides.pgm?task=agentinfo&agent=" & Chnger _
        , ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$4")
 
End Sub

It works obviously, but overwriting would be ideal.