This is a VBScript Macro (packaged inside an Excel .xlsm file) designed to automate validation of bulk CAMT XML files against XSD schemas.
Manually validating XMLs using tools like Altova Spy was a nightmare — especially when you have 1000+ files coming from LUAT testing 😩. This macro fixes that by letting you validate all those XMLs in one click, view the errors right there, and even remove duplicate entries instantly.
Say goodbye to mind-numbing manual XML checks 👋 and hello to smooth, automated validation workflows 🚀.
- ✅ Bulk validate CAMT.052 / CAMT.053 XMLs against their corresponding XSD schemas.
- 📁 Upload 1000+ XMLs at once from a predefined folder.
- 🧹 Instantly remove duplicate records with one click.
- 📄 View all validation errors in the same Excel sheet for easy analysis.
Make sure your folders look like this before using the tool:
