Vba to save certain rows to a txt file?

[JumboCactuar]

Hi,
Im wanting to save values from:
range B2:E20

With a space between each column value anf saved as txt (overwriting existing txt file without prompt)

I think i need to use "saveasCopy" but not sure how to save just the range and to a specific location

Any help appreciated

 

[BrianJN1]

I think this will suffice, Just replace DIR with your destination:

Sub ToText()
Range("B2:E20").Select
Application.CutCopyMode = False
    ChDir "C:\Dir"
    
ActiveWorkbook.SaveAs Filename:="C:\Dir\Grid.txt", FileFormat:=xlTextWindows
End Sub