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?