Newbie: How to Print by VBA a Single Page in a Worksheet

[L.A. Lawyer]

I want to create a VBA snippet that will only print a single named page in a
worksheet to a txt file called "c:\info\excel.txt".

How is that done?

 

[Dave Peterson]

One way is to copy the sheet to a new workbook and save it from there, then
close that workbook:

Option Explicit
Sub testme01()

ActiveSheet.Copy 'to a new workbook

With ActiveWorkbook
.SaveAs Filename:="c:\info\excel.txt", FileFormat:=xlText
.Close savechanges:=False
End With

End Sub