Exporting a specific range to a text file

[thunderhead]

I thought this deserved a topic of its own, although I made a post for the same doubt in an unrelated thread on the forums:


If I have a workbook with graphics (i.e. every worksheet has a standard header with the company logo etc.), but in the rest of the worksheet I have a range of data which I want to export as a text file, is it possible?

I want to export a particular range in a worksheet to a text file (the range may contain dates as a data type too), and save that text file (for simplicity, in the same folder as the workbook...but I'd like it if it throws open a "Save As" dialog box!).

It'll be nice if the columns are tab space and the rows have a carriage return separating them.

(I tried recording a macro, but it said this kind of sheet is not compatible or something along those lines).

 

[Joe4]

Please do not start multiple threads on the same topic. In the future, if you have updates, simply reply back to the original thread.

For others, you can see the updated question here:
http://www.mrexcel.com/board2/viewtopic.php?t=287406&highlight=