Need to modify the data in .xml file from the Excel Macro code

Question

I have an .xml file with me. The code in the xml is as follows

<?xml version="1.0" encoding="utf-8"?>
<Data>
<Table Id ="L2-MP3">
<Row>
<Parameter Name="TestID">1</Parameter>
<Parameter Name="Scope">L2</Parameter>
<Parameter Name="Description">m1dB_48K_16b_AP.wav</Parameter>
<Parameter Name="Format">wma</Parameter>
<Parameter Name="Input">c:\Data\Test\Standard\m1dB_48K_16b_AP.wav</Parameter>
<Parameter Name="Operation">15000,stop</Parameter>
</Row>
</Table>
</Data>

Here my requirement is, if you observe the description and the input part, there are some digits as 48, 16 and AP. not i need to fetch that values from the excel macro Module.

As i have the values ready in the Module, can any only please help me how to get the values into this .xml file. Also tell me how to construct the bridge between them and how to use the variables here in .xml file from the excel macro. and as shown 48, 16 and AP in that file are variable according to the requirement.

Your suggestion is very valuable for me.

I would be really thank full if you could help me in this regard?

[Here is a nice solution : Creating Excel Macro for Exporting XML to a certain folder ][1] [1]: stackoverflow.com/questions/15142523/… — kris
– kris, Commented Sep 16, 2014 at 15:00

Community · Accepted Answer · 2017-05-23 10:33:25Z

0

I would suggest that you import the XML in EXCEL more information

TUTORIAL : Import XML to an EXCEL file

the official site

and then try to seperate wanted piece parts of your input with the function MID in excel

TUTORIAL : MID function in EXCEL

Hope that this solve your problem.

About the macro, sorry I'm looking for a similar solution EXCEL, create a XML-file from a data in table via vba code

(I found a solution : Creating Excel Macro for Exporting XML to a certain folder.)

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 23, 2014 at 12:47

kris

3144 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Need to modify the data in .xml file from the Excel Macro code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related