Hi

I was given this macro and ive amended but just trying to finish off.


It saves the active workbook as a copy called summary1.xls in a new subfolder created. What im trying to do is break the links in the new summary1.xls after it saved to new location.


Can this be done?


Sub PERIODEND()
 
    Dim sName As Variant, bFolder As String, dest As String
    
    sName = InputBox("Subfolder name")
    If sName = "" Then Exit Sub
    
    bFolder = "T:\Passenger Accounts\SHARED\passacc\Excel\passacc\backup"
    
    
    If Dir(bFolder & "" & sName, vbDirectory) = "" Then
        MkDir bFolder & "" & sName
    End If
    dest = bFolder & "" & sName & ""
    
    ActiveWorkbook.SaveCopyAs dest & "NEW SUMMARY1.xls"