How can we open a notepad, write something into it, close that file by saving it as .xml

[get2noesks]

Hi Team,

I was working on this XML file creation through VBA and I am stuck at a stage where I have to write the contents to notepad recursively.

For instance, i have some 10 XMLs to prepare and I want each XML to be copied in a new notepad respectively and saved with .xml extension.

Basically I need help with
1) Opening a notepad file using VBA
2) Writing the content to notepad in XML tags format.
3) Saving the notepad recursively as .xml

Please help me in this regard.

Thanks
Saurabh

 

[VBA Geek]

When working with XML it's better to use the reference to Microsoft XML, v x.x (x.x is the latest version number you've installed, it should be either 5.0 or 6.0 normally)

you can read here:

https://msdn.microsoft.com/en-us/library/Aa468547.aspx

https://msdn.microsoft.com/en-us/library/ms763701(v=VS.85).aspx

 

[get2noesks]

Hi VBA Geek,

I need VBA code to access notepad and close it as an XML. I am not sure how do these links help?

Regards
Saurabh

 

[VBA Geek]

what is the file extension of the file?

 

[get2noesks]

The extension of file is .xlsx

 

[VBA Geek]

so you want to convert an excel data set to XML, you don't need to use notepad

 

[get2noesks]

Hi,

It's actually set of tags listed under a "Source System" and "Message Type" combo. Suppose A is the Source System and it has n message types; For each combination of source system and message type there are list of tags which needs to be created as separate XML file.

A-MsgType1-10 tags--> 1 XML
A-MsgType2-5 tags--> 1 XML
.
.
.
.
and so on....

Please advise on what can be done?