Macro VBA to update information in xml file

[Vasilchyk Vladik]

Good day

In general, such a question.
There is an excel file with fields

ID	Name	Price
101	Pos#1	10
102	Pos#2	20

and there is an xml file of this format

<offer available="true" id="101">
<price>10</price>
<currencyId>UAH</currencyId>
<categoryId>91456</categoryId>
<name>Товар №1</name>
<description><![CDATA[
<p>AAAAA.</p>]]></description>
<vendorCode>90/5</vendorCode>
<stock_quantity>1</stock_quantity>
</offer>

The task is that when you press a button in Excel from the desired line, focusing on the product id, information about the updated price is taken and the price in the xml file is updated with a reference to the product id.

That is, I change the price in Excel for 1 product to 12, and the second to 9, and press the macro start button. The price in the required xml file changes according to the principle for the product with id 101, the value in the <price></price> field changes from 10 to 12, and from 20 to 9 from id 102. Nothing else in this file changes.

Thanks for answers
And sorry for my bad english

 

[Vasilchyk Vladik]

Domenic, i don't even know how to thank you. Everything works great.
Thank you very much for spending so much time on my problem.
The problem is completely solved. Everything works as I need.

 

[Domenic]

That's great to hear, I'm glad I could help.

Cheers!