Hello,
I am relatively new to VBA, so apologies if this is naive but I have been struggling with this. I have tried to look through past posts on this subject but have had a hard time resolving having headers and tab file output in the same solution (individually yes, but the code in each answer seemed very different and didn't know how to combine them. I am using Office 2013.

I have an excel file with 12 columns and 123 rows. The first row is a header row that I would like repeated in every file, along with one row of data in each file (so 122 files total). I need the files to be named what is in column A for each row, but that column not be included in the file (so column 2-12 will be written to file). Finally, I need the output saved as a Tab separated txt file.

Thank you very much in advance for your help...having a hard time figuring this one out on my own.

EcoHIV_metadata.xlsm