macro which saves the cell values of every column of every worksheet to one txt list?

[forhekset]

Hi guys, this is my first post on this forum!

I know this will sound really unsophisticated, but I'm looking for a macro that, when executed, will save every cell value of every column of every worksheet into one single .txt list. To make that clear, the text file wouldn't be a table, but simply a list of all the cell values, cell value after cell value.

Basically the macro would do something along these lines:
1. In worksheet 1, go to the first column, grab the cell values of the whole column and list them in the text file.
2. Go to the 2nd column, grab the cell values of the whole column and list them in the same text file as in step 1.
3. Do this until there are no more columns in worksheet 1.
4. Go to the 2nd worksheet and do the same.
5. Do this until there are no more worksheets in the workbook.

Does anyone know how to do this?
The resulting text list doesn't have to look good. Basically I would like to have the data of a whole worksheet saved in a single .txt file, in list format.

Since I'm kinda in a hurry, I also posted this thread on another Excel forum - just so you know. :>

If anyone decides to help me with code, comments in the code are optional but welcome, as I do want to learn VBA & the macro language (I'm totally new to this).