I'm trying to build a simple macro to take a file, find replace from a list, and save as listitemX.txt
template.xls
This is the first file for _____.
List.xls
Bob
Joe
Mary
Should create:
Bob.txt
"This is a file for Bob."
Joe.txt
"This is a file for Joe."
Mary.txt
"This is a file for Mary."
Anyone have a simple sample?
template.xls
This is the first file for _____.
List.xls
Bob
Joe
Mary
Should create:
Bob.txt
"This is a file for Bob."
Joe.txt
"This is a file for Joe."
Mary.txt
"This is a file for Mary."
Anyone have a simple sample?