Hi all,




I'm pretty new at writing scripts. But I'm having a hard time figuring out how to write a simple Macro in VBA to allow multiple xml files to be edited and saved by either removing or replacing a certain text.



For instance I need to delete, from multiple XML files, <!ENTITY % ISOEntities PUBLIC "ISO 8879-1986//ENTITIES... etc


the other thing is I need to replace "&deg" to "°deg" within the same XML files.


Thank you for any help.

This is a relatively straightforward question and similar questions have been asked before so we aren't going to re-invent the wheel for you. Do a search for 'Batch find replace' and you will see lots of threads with code. A few minor changes will allow those macros to work on your specific requirements.

If you get stuck, post back here with a description of your sticking point, the code you are using and include a link to the original thread where you got it from.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Here is one such thread to get you started
https://www.msofficeforums.com/word-...ocx-files.html

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia