Use the sheet copy method to copy as a new workbook then do File/Save As on that.
Regards
BrianB
================================================== ==============
goepf wrote in message ...
I'd like to save a sheet as a .txt file out of my workbook without
closing the actual workbook and keeping the workbook as my .xls
format.
Thanks for any help!
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/