Save sheet as .TXT out of Workbook

[goepf]

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!

 

[BrianB]

Use the sheet copy method to copy as a new workbook then do File/Save As on that.


Regards
BrianB
================================================================

 

[goepf]

Thanks that's what I did. If it helps somebody, here is an example fo
code:

Dim FileName As String, path As String, DLSfile As String

FileName = Windows.Application.ActiveWorkbook.Name
path = "DestinationPath"

Sheets("toCopy").Select
Sheets("toCopy").Copy
DLSfile = "DL72112.txt"
ActiveWorkbook.SaveAs FileName:=path & DLSfile, fileFormat:=xlText
CreateBackup:=False
ActiveWindow.Clos