Clear an XML Map of all content
 

Hi,

Is there a simple line of VB that can be used in a macro to delete al
records from an XML map?

Thn

--
DangerMous
-----------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...fo&userid=2775
View this thread: http://www.excelforum.com/showthread.php?threadid=53805

Clear an XML Map of all content
 

try this
Dim myListObject As ListObject
Set myListObject = ActiveSheet.ListObjects(1)
Dim q As Integer
For q = myListObject.ListRows.Count To 1 Step -1
myListObject.ListRows(q).Delete
Next q

"DangerMouse" wrote:


Hi,

Is there a simple line of VB that can be used in a macro to delete all
records from an XML map?

Thnx


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=538053