Save worksheet to unopen workbook (VBA)

[Big Lar]

ActiveWorkbook.SaveAs Filename:=Environ("UserProfile") & "\OneDrive\The Razz\DataBases\PLAYERS2018.xlsx", _
        FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWorkbook.Close

I need to use the worksheet in another workbook “PLAYERS2018Userform”.
I’m currently manually opening both workbooks, moving(create copy) the worksheet, deleting the existing “PLAYERS” worksheet and renaming the moved worksheet.
Can someone suggest how to add code to my procedure to automate this when “PLAYERS2018Userform” workbook is not open?