Create individual text files from multiple rows

Hello Cagey1953,

Welcome to the forum!

This macro will create the individual text files from each row of the ActiveSheet. The firstcell is assumed to be "A1". You can change this if you need to.

Since you did not say where the files are to be stored, you will probably have to change the variable FilePath in the macro to the folder you will be using.

The rows are parsed 2 columns at a time. One column is for "List" and the other is for the "Address". Each row is assumed to have a variable number of addresses. The macro finds the end of each row, parses the data, and outputs that to new file.

Copy the code and paste it into a new VBA Module in your workbook.

Please Login or Register  to view this content.

Hello cagey1953,

Your welcome. Brilliant, I am glad you got it to run with no problems.