Hi,

Hope someone can help with this one.

I've written a macro that creates a text file with 3 columns of data.

I now need to add a line at the beginning of the text file. I can't
add it before saving as text for example because then the text file
contains tabs in A2 and A3 and this is a problem in this application.


So I need to find some way to add a line of text to the beginning of a
text file in an excel macro.

how would I go about writing directly to a text file without needing to
open the file in excel, adding text to a cell and closing again??

Any ideas?


--
lif
------------------------------------------------------------------------
lif's Profile: http://www.excelforum.com/member.php...o&userid=35745
View this thread: http://www.excelforum.com/showthread...hreadid=563543