vbscript import xml data to excel

[joaodaffonsojr]

Hello !
I have an excel spredsheet that needs to be completed with some static data and also variable data. This variable data is in a XML file, that I need to get some nodes and put this data in the excel spredsheet. I have done already a vbscript to complete the static data, but I don´t know how to use the XML inside the vb script.
Any help is very welcome !
thanks in advance

omiexcel.vb
OS_25764_dados_ecalc.xml

[jdc2000]

Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.

[joaodaffonsojr]

Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.

It has to be with vbscript because I use a software that automates the process, and this software rins the vbscript.

[jdc2000]

You could still use Excel to import the .xml data and transfer it, but automate that process using VBScript.

Possibly useful links:

https://docs.microsoft.com/en-us/pre...-side-vbscript

https://www.softwaretestinghelp.com/...l-tutorial-11/

https://automationscript.com/uft/rea...sing-vbscript/

[mmx88_ValidUser]

Consider serialization