Macros To Save Worksheet as New xlsx file & Save Another Worksheet As A Text File

Hi,

It needed a bit of alteration as you can se, this should work though

Sub Steffen()

Dim newWb As Workbook
Dim oldWb As Workbook

Set oldWb = ThisWorkbook

Open "C:\\Users\Path\" & Sheets(4).Range("C6").Value & ".txt" For Append As #1
    For i = 1 To Sheets(3).UsedRange.Rows.Count
        Print #1, Sheets(3).Cells(i, 1).Value
    Next i
Close #1

Sheets(2).Range("A1:K" & Sheets(3).UsedRange.Rows.Count).Copy
Application.DisplayAlerts = False
Set newWb = Workbooks.Add
    With newWb
        .Sheets(1).Range("A1").PasteSpecial xlPasteAll
        .SaveAs "C:\Users\Path\" & oldWb.Sheets(4).Range("C8").Value & ".xlsx", FileFormat:=51
        .Close
    End With
On Error GoTo err

err:
Application.DisplayAlerts = True

End Sub