PDA

View Full Version : trouble saving excel to tab delimited text file



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