Export Multiple Cells Into Multiple *.txt Files

I have a very similar issue as to what is described in this thread.

http://www.excelforum.com/excel-prog...-encoding.html

I have an excel spreadsheet about 2000 rows long and only 2 columns wide. I need each row to be exported into its own txt file. The contents of the txt file should be what's in Column B. And the name of the txt file should be what's in Column A. I tried modifying some of the code in the above thread, but honestly don't know enough about excel macro's and vba to get any positive results.

I would appreciate some help.

Thanks for the quick response and help.

That didn't quite work for me though.

It did create a large number of text files, all with the proper name except for the first one. The first txt file created was named the value in column B instead of column A. The other problem is that all of the files are blank. None of the Column B data wound up in the txt files.

While waiting for a response last night I was playing around with the code in the thread I mentioned earlier. I was able to get it to work, well....mostly. It will create all the txt files named perfectly. It will dump all the data into the text files perfectly. But there seem to be hidden charachters that are preventing it from working for my application.

For example. Text file one is named p0001s1.txt and its contents are telnet 10.9.1.65.

If I rename this file to .bat and execute with command prompt it shows 'telnet' is not recognized as an internal or external command, operable program or batch file.


What are these hidden charachters that are being copied over from excel? Any idea how I can get rid of them?

Again, I have no VB experience. I understand some basic concepts and have dabbled in Objective C, but thats it. I greatly appreciate any help.

Here is the code I'm using right now.

Please Login or Register  to view this content.

Ascii was the answer I was looking for!

UTF-8 format was inserting some hidden characters but ascii works just fine.

Here is the code that I ended up with.

Hope it helps someone else.

Please Login or Register  to view this content.

thanks to all who contributed to this thread. i had a list of 20,000 patients and i needed an easy way to convert the list into individual files. awesome!!!