VBA to open specified workbook and "Save As" a cell value .xlsx

[SevenOut]

C2=Date (8.15.22) fore example.
I would like to create a button macro that opens a workbook (file path will be recorded on a "setup" worksheet, for example: Setup!A2) and save that workbook with the value of C2 & .xlsx (8.15.22.xlsx)

Ultimately there will be seven of these buttons, one for each day of the week. Each opening the exact same file, naming that file to each buttons corresponding date.
I would like the new file to remain open until manually closed as well.

I do have a macro workbook that does similar, creating a saved copy of the directed workbook for each day of the month. I am struggling adapting it however.
Any help would be appreciated.

 

[SevenOut]

Here is what I'm working with:

Sub Sat_Button()
    Dim ws As Worksheet
    Dim wb As Workbook
    Dim rng As Range, c As Range
    Dim wbPath As String, NewPth As String
    Dim NewNm As String

    Set ws = ActiveSheet
    Application.ScreenUpdating = False
    With ws
        Set wb = Workbooks.Open(.Range("F160").Value)
        wbPath = wb.Path & "\"
        Set rng = .Range("V11")
        For Each c In rng.Cells
            If c <> "" Then
                wb.SaveAs (wbPath & "\" & c & ".xlsx")
            End If
        Next c
    End With
End Sub

F160= directory path of workbook to be opened
V11= name to save the workbook as (date in the 8.15.22 format)

I need the workbook that is opened to be "Save As" in the same directory, not a new directory.
So far,

wb.SaveAs (wbPath & "\" & c & ".xlsx")

is flagged in the debugger.

Anyone with input??

 

[SevenOut]

Troubleshot the problem, the V11 value was not formatted correctly. =TEXT function fixed and all works great.