VBA save file

Hi,

What i have currently is a query that fetches a table to a sheet. I want to build a macro that exports the table to a new workbook and saves it to a custom folder.
Therefore what i need to do is:

Determine What to save (Table), this is always the same table, even though the table range varies based on the query data.
Determine Where to save and with what name (which folder), this should be a box that the user determines the place
Determine the saved format as xlsx

As i am very new, what i have so far is:

Sub Save_Workbook_NewName()

    Dim workbook_Name As Variant
    workbook_Name = Application.GetSaveAsFilename
    ActiveWorkbook.SaveAs _
        Filename:=workbook_Name, _
        FileFormat:=51
    
End Sub

>> This however saves just a "file", not even xlsx.
Could someone help me build a saving macro with the guidance above?

Thank you!