I'm looking to create a
.txt file for each value in
column A containing the corresponding values in
columns B and C
The more I looked at this the more I found it to be a useful little macro. In order to keep it from processing blank rows (and locking up my Excel) I rewrote the code to only create a file while there is data available. Also, the use of
Feel free to use and modify as you wish. Thanks for the great idea.
This macro will take each value in
Four years later I decided to come back to my first SU question - my very beginnings to VBA. This is better, but will overwrite any file that already exists