I have a worksheet in a workbook that I would like to export out as a text
file and not affect the workbook, and name the text file to save as.

By hand?

File - Save As
Under "Save as type:" choose Text (Tab Delimited) or CSV (Comma Delimited)

....or from within a VBA event?

ThisWorkbook.SaveAs Filename:="MyText.txt", FileFormat:=xlTextWindows

"Slinger" wrote in message
...
I have a worksheet in a workbook that I would like to export out as a text
file and not affect the workbook, and name the text file to save as.

I would like to automate the task by using a button to do the write to a file
- pretty much a newbie when it comes to VBA

"JPW" wrote:

By hand?

File - Save As
Under "Save as type:" choose Text (Tab Delimited) or CSV (Comma Delimited)

....or from within a VBA event?

ThisWorkbook.SaveAs Filename:="MyText.txt", FileFormat:=xlTextWindows

"Slinger" wrote in message
...
I have a worksheet in a workbook that I would like to export out as a text
file and not affect the workbook, and name the text file to save as.

Double-click on ThisWorkbook in your VBA Project and add a sub with the line
I gave you below. For example:

Public Sub SaveAsTXT()
ThisWorkbook.SaveAs Filename:="MyText.txt", FileFormat:=xlTextWindows
End Sub

Then assign this macro to the button you want from within your workbook. You
can assign macros to pictures, this would be the simplest way. Right-click
your image and choose "Assign Macro," then pick your SaveAsTXT macro from
the list.

"Slinjger" wrote in message
...
I would like to automate the task by using a button to do the write to a
file
- pretty much a newbie when it comes to VBA

"JPW" wrote:

By hand?

File - Save As
Under "Save as type:" choose Text (Tab Delimited) or CSV (Comma
Delimited)

....or from within a VBA event?

ThisWorkbook.SaveAs Filename:="MyText.txt", FileFormat:=xlTextWindows

"Slinger" wrote in message
...
I have a worksheet in a workbook that I would like to export out as a
text
file and not affect the workbook, and name the text file to save as.

Not sure I understand the question.

All you have to do is select File, Save as, then choose .CSV type in the
save as type drop down....

The .csv format is a text file. If you need to you can just change the
extension once you saved it down..

Is that what you meant?

"Slinger" wrote:

I have a worksheet in a workbook that I would like to export out as a text
file and not affect the workbook, and name the text file to save as.

Hi Slinger

Activate the sheet you want to save. click on File|Save As. Select a CSV
or other text file format, name it and save. It only saves the one sheet,
without affecting the others. It also changes the name of the sheet to the
saved name. You can just change this back

"Slinger" wrote:

I have a worksheet in a workbook that I would like to export out as a text
file and not affect the workbook, and name the text file to save as.