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.