I have:
1) A .txt file template with over 1,000 unique strings sprinkled through the document.
2) An Excel Workbook with these 1,000 strings in column "A", and slight variations of these strings in the adjacent "X" number of columns (a variable number of columns. For starters, lets assume 50 columns).
I need some pointers writing VBA script or an Excel Macro that will:
1) create as many new files from the template as columns "X" in the spreadsheet. Each file is to be named according to the corresponding column header in the Excel file.
2) Within each newly created file, FIND each unique string from the template, and REPLACE it with the string in the corresponding row (but appropriate indexed column) of the spreadsheet.
Any suggestions?
1) A .txt file template with over 1,000 unique strings sprinkled through the document.
2) An Excel Workbook with these 1,000 strings in column "A", and slight variations of these strings in the adjacent "X" number of columns (a variable number of columns. For starters, lets assume 50 columns).
I need some pointers writing VBA script or an Excel Macro that will:
1) create as many new files from the template as columns "X" in the spreadsheet. Each file is to be named according to the corresponding column header in the Excel file.
2) Within each newly created file, FIND each unique string from the template, and REPLACE it with the string in the corresponding row (but appropriate indexed column) of the spreadsheet.
Any suggestions?
