Creating Text Files From VBA in Excel

[mathare]

Can Excel create a new text file with VBA and write to it?

If so, how??

Or will I have to write the data to a new worksheet and save that worksheet as text?

[TheOldhamWhisper]

Try here: http://www.exceltip.com/st/Replace_text_in_a_text_file_using_VBA_in_Microsoft_Excel/494.html

[mathare]

Of course, that's how you do it.

Cheers Oldham :)