VBA, gem excelark i ny excelfil

Jeg plejer at bruge noget der ligner dette her - du kan evt. selv lege med at give et dynamisk navn eller hvad du måtte have brug for.

Worksheets(Array("Sheet1", "Sheet3")).Copy - opretter en ny excel fil inde i Excel, som man så kan arbejde videre med - fyld selv andre ark navne ind i Array'et.

Sub Demo()
    Dim wkbCopy As Workbook
    Dim wksTemp As Worksheet
    Dim lTemp As Long
   
    ' Copy
    Worksheets(Array("Sheet1", "Sheet3")).Copy
    Set wkbCopy = ActiveWorkbook
   
    ' Change formula to values
    For Each wksTemp In wkbCopy.Worksheets
        lTemp = wksTemp.UsedRange.Rows.Count
        wksTemp.UsedRange.Value = wksTemp.UsedRange.Value
    Next wksTemp

    ' Save
    wkbCopy.SaveAs Filename:="C:\Test\NewFile.xlsx" ' Change filepath and name
    wkbCopy.Close

    Set wksTemp = Nothing
    Set wkscopy = Nothing
End Sub