nmoloney1968
New Member
- Joined
- Feb 18, 2007
- Messages
- 20
I have a large dataset that will be read by a statistics package. The data has to be a txt file for each sample (the sample is a text string that is being analyzed). So I have a Filename column (A) and a Sample column (B), which have 1400+ rows (i.e. 2 x 1400 cells). How can I program a VBA macro to take the contents of Column B, row n, put it into a text file, then save that text file with the name in Column A, row n, and loop on down all the rows so I end up with 1400 or so files?
The text in the Sample can be quite long (but not more than say 2000-ish characters).
Neil.
The text in the Sample can be quite long (but not more than say 2000-ish characters).
Neil.