View Single Post
 
Old 06-30-2020, 12:47 PM
Rolo18 Rolo18 is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2020
Posts: 20
Rolo18 is on a distinguished road
Default Replacing/Removing XML file lines

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.
Reply With Quote