not quite what i was looking for, looking to replace the characters (< and >) in the text file with "^"....any idea? i know this will somehow involve automated opening of each file and using the replace command but thats all that I have
Hey,
I have this code to download the attachments in my outlook inbox to a specified folder as .txt files. I was wondering if anyone had a way that I could replace the "<" and ">" characters in the files (as original filetype is .xml) with a "^". I would prefer to do this all in the same step...
Found this coding online, was wondering if anyone had any idea how to modify this to deal with .txt documents.
Public Sub BatchReplaceAnywhere()
'Based on a macro by Doug Robbins
'with additional input from Peter Hewett
'and Greg Maxey to replace text in all
'the documents in a folder...
Hey, Was wondering if someone could lend a hand. I have some VBA code for outlook that allows me to take all the attechments in a selected folder and save them as a .TXT file from xml. I am ultimately looking to add all the data into an excel database but first must switch all the text for...
Hey, Was wondering if someone could lend a hand. I have some VBA code for outlook that allows me to take all the attechments in a selected folder and save them as a .TXT file from xml. I am ultimately looking to add all the data into an excel database but first must switch all the text for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.