How to generate a text file from Excel using a macro or script?
 

I need to know the way of generating a text file from data availbabe in an
Excel spreadsheet either using a Macro or a Script!

Asume if I have some data in few cells such as C5, C6 and C7
then if I have a simple formula like Sum in another cell like C8 to get the
total of the above mentioned cells. How do I display the values in those
cells in a tect

Please be kind enough to reply me if you know this!
Thanks a lot!
-Frank-

How to generate a text file from Excel using a macro or script?
 

Hi Frank

See
http://www.mcgimpsey.com/excel/textfiles.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
I need to know the way of generating a text file from data availbabe in an
Excel spreadsheet either using a Macro or a Script!

Asume if I have some data in few cells such as C5, C6 and C7
then if I have a simple formula like Sum in another cell like C8 to get the
total of the above mentioned cells. How do I display the values in those
cells in a tect

Please be kind enough to reply me if you know this!
Thanks a lot!
-Frank-