Feliks
05-18-2011, 09:51 PM
Greetings,
I'm trying to export my worksheet to a tab delimited text file. I've been trying to use Chip Pearsons code found here:
http://www.cpearson.com/excel/ImpText.aspx
I've been successful in exporting the file except that when I chose vbTab for the delimiter type, I get a double set of parenthesis for every empty cell in the selection in the text file. I've tried changing the formatting type to a couple different types but that hasnt helped. Any assistance would be greatly appreciated.
thanks,
Marc
I'm trying to export my worksheet to a tab delimited text file. I've been trying to use Chip Pearsons code found here:
http://www.cpearson.com/excel/ImpText.aspx
I've been successful in exporting the file except that when I chose vbTab for the delimiter type, I get a double set of parenthesis for every empty cell in the selection in the text file. I've tried changing the formatting type to a couple different types but that hasnt helped. Any assistance would be greatly appreciated.
thanks,
Marc