how to export Unicode data to multiple text files

Hi,

I have not been able to find a solution to these two issues for months.


My sheet "UNIVERSITIESOtherName" is made of two columns ID, UniversityOther (university names in non-english characters):



ID UniversityOther
87 Երևանի Հայբուսակ Համալասարան
190 جامعة الخليج العربي
191 الجامعة الخليجیة
192 جامعة البحرين
237 Белорусский государственный экономический университет



I need to export them to multiple text files each named as ID.txt and containing the associated UniversityOther cell content only.



I found this 2 posts with similar issues but I could not adapt the macro to my specific case.


http://www.ozgrid.com/forum/showthread.php?t=76112
http://www.ozgrid.com/forum/showthread.php?t=54904


Thank you very much for your time and suggestions.

FF

Please Login or Register  to view this content.

Originally Posted by snb

Please Login or Register  to view this content.

Thanks. I get a run time error '75'