Extracting XML data
Hello everyone -
I need some help with this one. From a driver script, I need to open a file containing XML data, verify whether a particular tag is set to true/false and then run a child script accordingly. The file is not, .xml, it's a proprietary file, so I'm wondering if that will be an issue too.
thanks in advance for any help,
Re: Extracting XML data
You could load the file and then cycle through the file looking for you key.
Dim intfileNumber As Long
intfileNumber = FreeFile ' Get file handle
Open FileName For Input As intfileNumber ' open the file
Do While Not EOF(intfileNumber) ' Loop until end of file.
Line Input #intfileNumber, stTemp ' Read line into variable.
If InStr(1, stTemp, "Value") > 0 Then