October 5, 2021
I need this help, I tried many ways but not could not figure out.
I have a folder (c:\mydocument) which contains multiple xml files (Lets say 100) and also 1 excel file (name=usermapping" which contains Column A multiple email id (lets say 50) eg. firstname.lastname@example.org and column b also has different email ids email@example.com
I need a VBA code, which will open these xml files and search for email -ids in column A of excel file and replace the xml with Column "B" email ID's.
Any help in this regard would be highly appreciable. If you need any questions or clarification, please do reply to this message.
December 7, 2016
One can tell you have not glanced at the forum rules, if you had then you would know that uploading a sample file is a good way to get response. Posting in correct forum can also help.
Any way, is VBA the only solution you consider? Depending on where and how you want the end result to be you can use Power Query.
- End result, how and where?
- Sample files please.