Log In
Register
Home
New Member
October 5, 2021
Offline
Hi Friends
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. abc@gmail.com and column b also has different email ids abcdef@gmail.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.
Warm regards
Johnny
VIP
Trusted Members
December 7, 2016
Offline
Hello,
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.
Br,
Anders
1 Guest(s)
