Hello,
I've searched the forum but can't find a thread that addresses this situation:
I have a folder (C:\Files) of many LTR files containing tilda-delimited mailing data. Each letter contains data for a different mailing template, so I don't want to combine them into one XLS file. Instead, I'd like to create a script to open each LTR file, separate the data using Text-To-Columns with tilda-delimination, and then save that file as an XLS file using the same name as the LTR file that was originally opened.
The goal is for the script to run through all the files in the folder, so if I start with 10 LTR files, after running the script, I should end up with 10 LTR files and 10 XLS files in the folder.
Any help would be greatly appreciated!!
Mike
I've searched the forum but can't find a thread that addresses this situation:
I have a folder (C:\Files) of many LTR files containing tilda-delimited mailing data. Each letter contains data for a different mailing template, so I don't want to combine them into one XLS file. Instead, I'd like to create a script to open each LTR file, separate the data using Text-To-Columns with tilda-delimination, and then save that file as an XLS file using the same name as the LTR file that was originally opened.
The goal is for the script to run through all the files in the folder, so if I start with 10 LTR files, after running the script, I should end up with 10 LTR files and 10 XLS files in the folder.
Any help would be greatly appreciated!!
Mike
