VBA - XML SelectSingleNode - Syntax Problem

[CJames]

Refs - See attached images.

My XML file structure is a config file: It works fine

Simply trying to change date between the quotes of "2017-05-10" 'in the StartDate value to 2017-05-11

see attached image for the pop up err on bold line in code

My code I Have so far.

<?xml version="1.0"?>
<configuration>
  <configSections>
     ...some xml struc
  </configSections>
 
  <appSetttings>
     <add key="xxx" value="yyy" />
     <add key="xxx" value="www" />
     <add key="StartDate" value="2017-05-10" />
     <add key="EndDate" value="2017-05-25" />
     <add key="zzz" value="nnn" />
  </appSettings> 
 
 etc
 
</configuration>
 
'Access VBA 2010
 
Dim wXML As Object, xFile As String
 
Set wXML = CreateObject("Microsoft.XMLDOM")
 
xFile = "C:\CTI Group\ArchiveClientTools\v2-0-0\ArchiveClientTools\SRIPArchiveClientForm.exe.config"
 
wXML.Load (xFile)
 
'errs here.
 
wXML.documentElement.SelectSingleNode("configuration/appSettings/add key/[@Name='StartDate']/value").InnerText = "2017-05-11"

No joy. Am I missing something simple?

Thanks. :o)

[CJames]

With a little help we got it figured out... Easy in hindsight... not so looking forward before it worked...

*************************************

Dim wXML As Object, xFile As String
    Set wXML = CreateObject("Microsoft.XMLDOM")
    xFile = "C:\CTI Group\ArchiveClientTools\v2-0-0\ArchiveClientTools\SRIPArchiveClientForm.exe.config"
 
    If wXML.Load(xFile) Then
        wXML.DocumentElement.SelectSingleNode("//add[@key=""StartDate""]").setAttribute "value", "2017-05-11"
        wXML.Save xFile
    Else
        MsgBox wXML.parseError.reason, , wXML.parseError.ErrorCode
    End If
 
    Set wXML = Nothing

[NeoPa]

Glad to see you got it sorted without help. I'm very unfamiliar with all the XML stuff unfortunately.