Created
February 26, 2018 03:25
-
-
Save DuongAQ/29ea7be14f91efff2add4d5ef67af52d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub RemoveLink_01() 'Excel VBA remove links from workbook. | |
Dim ar As Variant | |
Dim i As Integer | |
ar=ActiveWorkbook.LinkSources(1) | |
On Error Resume Next 'Bỏ qua các lỗi có thể xảy ra | |
For i = 1 To UBound(ar) 'Thực hiện vòng lặp xét các liên kết | |
ActiveWorkbook.BreakLink ar(i), xlLinkTypeExcelLinks | |
Next i | |
On Error GoTo 0 'Đưa cơ chế bẫy lỗi về dạng mặc định | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment