Hello,

I have below VBA code which moves sheets from active workbook. How to add a code which would open a dialog box allowing me choose Save as.

Sub CopySheet()
    Dim varLinks
    Dim strFileName As String
    strFileName = ActiveWorkbook.Path & ActiveSheet.Range("A1").Value & ActiveSheet.Name & ".xml"
    Sheets(Array("Overview", "Create ", "Edit Assign ", "Request Default", "Assign ", "Assign Cos")).Move ' Creates the new workbook AND DELETES THE OLD SHEET
     
     '=======================================================
     'Sometimes you need to kill the links.  Omit this block if this is not an issue
    varLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)
    If IsArray(varLinks) Then
        For i = LBound(varLinks) To UBound(varLinks)
            ActiveWorkbook.BreakLink Name:=varLinks(i), Type:=xlLinkTypeExcelLinks
        Next i
    End If
     'End Link killing code
     '=======================================================
     
    ActiveWorkbook.SaveAs strFileName
    ActiveWorkbook.Close False
    
    
End Sub