Export range to delimited txt.file

[mrmiyagi]

Hi,

I am not to good with macros, but I need one now. :)

If I want to export a range from a sheet into a delimited text file, what are my options?

I have a summary line at the end, which I don?t want to include. Also, I have a cell in the sheet with a date, which i would like to use when saving the file. I have seen some solutions, but none that I could get to work the way I would like. And sure it does not help that I am a complete moron when it comes to any kind of programming.......

[Bob Phillips]

Copy the range to a sheet in a new workbook, and save that as a text file. Do it with the macro recorder on, and you have your code.