Export rows to delimited txt files

[jmspen]

Hi all,

I've run pre-written macros before, but am definitely a novice about VBA. I have a problem that I am confident can be solved with a script but definitely need some help.

I have a spreadsheet with 1,000+ rows and 50+ columns, each row is a separate record. Here is what I need to do:
-Export each row as a separate txt file that is tab delimited for the columns
-Use the cell in the first column as the name of the txt file
-Preferably include the header row in each txt file (so each txt file would include 2 rows: first txt would have rows 1 and 2, next file rows 1 and 3, etc.); this would mean that the txt file name would need to come from the first cell in the subsequent (non-header) row

I really just need to be able to do the first two, the third would be the cherry on top.

Thanks for any help!
Jess

[CriticalBill]

A little verbose but will get the job done.

Please Login or Register  to view this content.

[jmspen]

Wow! Thanks CriticalBill! This is exactly what I needed!

Thanks again,
Jess

[jmspen]

Wow! Thanks CriticalBill! This is exactly what I needed!

Thanks again,
Jess