FIRST MACRO: XML EXPORT (TMX)
Given a xls file with two columns of text, the macro generates a simple TMX file ([url removed, login to view]) with the content of said columns and prompt where to save it.
REQUIREMENTS: Must be able to cope with cells with very long text and line breaks, must be able to handle long files without freezing, must accept Unicode text.
SECOND MACRO: SELECTIVE ELIMINATION OF COLUMNS
Given a folder with several xls file, the macro must browse each workbook and sheet, deleting all columns that don't contain specific key words in their heading.
Requirements: Must provide a dialogue box where file folder, key words and the line containg the header can be set, must be able to handle long files with several sheets without freezing, must accept Unicode text.
Delivery: Beginning of next week would be nice. Thank you.
I can develop the two macros for you with my current level of expertise. Being a coder and an excel modeler this task is easy for me and I can provide the complete solution within 2 days.