MrExcel Publishing
Your One Stop for Excel Tips & Solutions

save file as unix text file using VBA

Posted by harold sendon on November 19, 2001 8:42 PM

hello excel users!! do you guys have an idea of how to save an excel file so that it would be recognized as a unix text file? at the moment, i am accomplishing this in two steps, save the file as customized windows text file then use a file converter to convert it to unix file format. what i want to do is directly save it as a unix file. please help. thank you!

Posted by Dank on November 20, 2001 11:15 AM

Hello Harold,

I have written an add-in that I'm going to distribute on my new website. It will allow users to create text files other than those supported by Excel e.g. any delimiter rather than tab or comma. Seeing your post has given me the idea to include functionality to create files for Unix. Can you send me a sample Unix text file and in return I shall send you some code that will allow you to save your worksheets directly to that format. The email address is


Posted by harold on November 21, 2001 6:13 PM

Hi Dan,

Thanks for your interest. Sample unix text file is on its way to the information superhighway :)