Hi
I have part of a macro shown below that moves files into a new subfolder that ive created in a folder called backup.
It saves the workbook as NEWSUMMARY1.XLS no problem but im then trying to break the links after the file moved.
Any Ideas?
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"
I have part of a macro shown below that moves files into a new subfolder that ive created in a folder called backup.
It saves the workbook as NEWSUMMARY1.XLS no problem but im then trying to break the links after the file moved.
Any Ideas?
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"