writing excel file to separate tab separated text files with header in each

[gsindby]

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

[fredlo2010]

Hi see if this helps. Run the code named CreateFiles. Note that if there is a file with the same under the same folder it will be deleted and replaced with a new one.

Please Login or Register  to view this content.

Hope it helps

[Marc L]

Hi,

needs less than 20 code lines with standard VBA functions !

Code to paste directly in the worksheet module :

Please Login or Register  to view this content.

Enjoy it and don't forget to clik on bottom left star "Add Reputation", thanks !

[gsindby]

Thank you both so much. I ended up using Marc's reply and it worked perfectly!

[fredlo2010]

I am glad I was able to help. My code is longer indeed but easier to understand and debug. Just saying yeah its more than 20 lines!

Thanks