VBScript modify a value in a XML file

Question

I'm learning VBScript and I am trying to modify values on a xml file using vbscript but I always get an error with the variable "colNode":

Microsoft VBScript Runtime Error: This object does not support this property or method: 'colNode.Text

Here is my XML file:

<?xml version="1.0" encoding="utf-8"?>
<Configuration>
    <Text Name="Text1">Lorem ipsum dolor sit amet, consectetur adipiscing elit. </Text>
    <Text Name="Text2">Aliquam mattis quam lorem, ut sollicitudin dolor dignissim sed. </Text>
    <Text Name="Text3">Fusce cursus tellus eu consectetur rutrum.</Text>
</Configuration>

And here is my VBScript code:

    Set xmlDoc = _
    CreateObject("Microsoft.XMLDOM")

    xmlDoc.Async = "False"
    xmlDoc.Load(".\message.xml")

    
    Set colNode=xmlDoc.selectNodes _
  ("//Configuration/Text[@Name='Text2']")

    
    colNode.Text = "It's a test!"  
    xmlDoc.Save "C:\Scripts\Audits.xml"

Try Set colNode=xmlDoc.SelectSingleNode("//Configuration/Text[@Name='Text2']") — Theo
– Theo, Commented Apr 30, 2021 at 9:33
Try it and get the following error message: Required object: 'colNode — Noemie
– Noemie, Commented Apr 30, 2021 at 9:38

Theo · Accepted Answer · 2021-04-30 09:39:10Z

2

The SelectNodes method returns a collection of nodes (in this case a collection of just one) and if you want to use that, you need to iterate through that collection in order to change the text in every node in the collection:

Set colNode=xmlDoc.SelectNodes("//Configuration/Text[@Name='Text2']")
For Each node In colNode
    node.Text = "It's a test!"
Next

In your example however, you are seeking to change the text in only one specific node, so for that you ca use the SelectSingleNode method:

Set colNode=xmlDoc.SelectSingleNode("//Configuration/Text[@Name='Text2']")
colNode.Text = "It's a test!"

answered Apr 30, 2021 at 9:39

Theo

61.9k8 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Noemie Over a year ago

I got the following error message: Required object: 'colNode'

Tomalak Over a year ago

@Noemie That's because your XPath query selects nothing, so colNode will not be set properly. (In other words, the sample XML from your question is different from your real XML.)

Noemie Over a year ago

I try with "SelectSingleNode" (uppercase S) and it works

Tomalak Over a year ago

@Noemie If I had to guess, your real XML is in a namespace (xmlns="...") and you edited that out because you thought it was not important.

Collectives™ on Stack Overflow

VBScript modify a value in a XML file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related