Create text file

Giganews Newsgroups
Subject: Create text file
Posted by:  Rob (randwnob…
Date: Fri, 26 May 2006


I would like to create a text file from a worksheet (named according to the
value of a cell in that worksheet), and not have the workbook from which
that sheet is attached close.

ie say the workbook is called A.xls and I create a text file called B.txt. I
want to save and close B.txt and keep A.xls open.

Can anyone help me with that?