Saving to text file - tabs from empty cells ignored
 

Hi,

Wondering if anyone can point me in the right direction.

I have macro that creates a text file and saves it so that it can b
read by another program. This other program requires arguments at th
beginning of the text file.

So I set up the macro to enter the needed text for the argument in cel
A1 then enter the data in the following rows

For example:

A B C
-----------------------------------------
Mesh AutoCreate
1 2 3
2 2 2
4 4 4

When I save the file as txt and try to open it with my other software,
the argument is ignored because there are 2 tabs (in the empty cell
B1,C1).

If I manually open the text file in notepad and remove the tabs then i
works great.

So I need to figure out a way to append that text to the beginning o
the file "without" tabs.

thanks for any help,
Lui

--
li
-----------------------------------------------------------------------
lif's Profile: http://www.excelforum.com/member.php...fo&userid=3574
View this thread: http://www.excelforum.com/showthread.php?threadid=56334