export data from excel 2003 into NOTEPAD

I need to copy a range of cells A1:A20 from worksheet: Assy_txt_export
and paste it into NOTEPAD.

Also is there a way to name the textfile using the data from cell A24
from worksheet: Assy_txt_export.

Andrew P was nice enough to make this version for me, but I need to replace the Sub(test)) portion with a notepad command "Shown Below". (I'm having issues with Quotes in the text file) and Notepad seems to take care of this issue.

From AndY P
---------------------------------------------

Please Login or Register  to view this content.

-----------------------------------------------

I found this part on a forum, but I don't know anything about VB.
Can someone tweek it so it shows it is copying the info from worksheet: Assy_txt_export
And have it name the text file using the data from cell A24 from the same worksheet?

**************************************

Please Login or Register  to view this content.

****************************************

Feel free to contact me @: [email protected]
This way I can send a powerpoint slide showing what I'm trying to do.

Thank you for your support
Rob