Hi guys, novice here. I am trying to:
1) Open an XML file (C:\Users\GKC\Documents\data.xml) in Notepad
2) Clear the current contents
3) Paste the new data (data has already been copied)
4) delete "<?xml version="1.0" encoding"UTF-8" standalone="True"?>"
5) delete all "-" characters in the file
I have figured out how to open the XML file in Notepad with the code below, however I need some help on 2 through 5.
[VBA]Shell "notepad.exe C:\Users\GKC\Documents\data.xml", vbMaximizedFocus[/VBA]
Below are some similar threads that may help you guys help me out on this one, but there's nothing in them to do with opening an XML document in Notepad.
http://www.vbaexpress.com/forum/showthread.php?t=13737
http://www.vbaexpress.com/forum/showthread.php?t=27747
http://social.msdn.microsoft.com/For...-098928957165/