Good Morning Folk
I have a workbook which is saved by a different name using the code below, this works well with no issues. One of the sheets in the book contains links to another workbook. Is it possible to deactivte these links after the workbook is saved under its new name
Sub save_report_C()
Dim saveas As String
saveas = Range("F3")
ChDir "C:\Compliance Information\H&S\Audit Reports\"
ActiveWorkbook.saveas Filename:= _
"C:\Compliance Information\H&S\Audit Reports\" & saveas
End Sub
Many thanks for your help
JT
Bookmarks