Dear DD,Coba Script ini :
Dim a As Workbook
Dim b As Long
Dim c As VariantSet a = ActiveWorkbookc =
a.LinkSources(Type:=xlLinkTypeExcelLinks)
For b = 1 To UBound(c)
a.BreakLink Name:=c(b), Type:=xlLinkTypeExcelLinksNext b
Jika ada file link yang terprotect, maka tidak bisa nge-BreakLinks
TerimaKasih.
Pada Rabu, 7 Desember 2016 13:54, "'Dede Sulaeman'
[email protected] [belajar-excel]"
<[email protected]> menulis:
Dear BeExceller, Berikut scriptyang saya pakai : Sub Macro2() FlNm =
Range("A1").Value u = Range("F1").Value For x = 1 To u On Error Resume Next
Sheets("Sheet1").Select Sheets("Sheet1").Move
ActiveWorkbook.BreakLink Name:="" & FlNm& "", Type:=xlExcelLinks
Sheets("Sheet1").Select
Sheets("Sheet1").MoveBefore:=Workbooks("Book1").Sheets(1) Next x End Sub
Script ini hanya untuk BreakLink satu file saja. Jadi kalau Tiga file gimana
yah scriptnya? Salam, DD From:
[email protected][mailto:[email protected]]
Sent: 07 Desember 2016 8:43
To: [email protected]
Subject: [belajar-excel] BreakLink Dear Be Exceller, Saya mempunyai
file (sebut saja File A)yang formulanya nge-Link ke (3)tiga file yang berbeda.
Apa scriptnya yah kalau saya maunge-BreakLink “File A” tersebut. Salam, DD
#yiv6949709568 #yiv6949709568 -- #yiv6949709568ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6949709568
#yiv6949709568ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6949709568
#yiv6949709568ygrp-mkp #yiv6949709568hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6949709568 #yiv6949709568ygrp-mkp #yiv6949709568ads
{margin-bottom:10px;}#yiv6949709568 #yiv6949709568ygrp-mkp .yiv6949709568ad
{padding:0 0;}#yiv6949709568 #yiv6949709568ygrp-mkp .yiv6949709568ad p
{margin:0;}#yiv6949709568 #yiv6949709568ygrp-mkp .yiv6949709568ad a
{color:#0000ff;text-decoration:none;}#yiv6949709568 #yiv6949709568ygrp-sponsor
#yiv6949709568ygrp-lc {font-family:Arial;}#yiv6949709568
#yiv6949709568ygrp-sponsor #yiv6949709568ygrp-lc #yiv6949709568hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6949709568
#yiv6949709568ygrp-sponsor #yiv6949709568ygrp-lc .yiv6949709568ad
{margin-bottom:10px;padding:0 0;}#yiv6949709568 #yiv6949709568actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6949709568
#yiv6949709568activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6949709568
#yiv6949709568activity span {font-weight:700;}#yiv6949709568
#yiv6949709568activity span:first-child
{text-transform:uppercase;}#yiv6949709568 #yiv6949709568activity span a
{color:#5085b6;text-decoration:none;}#yiv6949709568 #yiv6949709568activity span
span {color:#ff7900;}#yiv6949709568 #yiv6949709568activity span
.yiv6949709568underline {text-decoration:underline;}#yiv6949709568
.yiv6949709568attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6949709568 .yiv6949709568attach div a
{text-decoration:none;}#yiv6949709568 .yiv6949709568attach img
{border:none;padding-right:5px;}#yiv6949709568 .yiv6949709568attach label
{display:block;margin-bottom:5px;}#yiv6949709568 .yiv6949709568attach label a
{text-decoration:none;}#yiv6949709568 blockquote {margin:0 0 0
4px;}#yiv6949709568 .yiv6949709568bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6949709568
.yiv6949709568bold a {text-decoration:none;}#yiv6949709568 dd.yiv6949709568last
p a {font-family:Verdana;font-weight:700;}#yiv6949709568 dd.yiv6949709568last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6949709568
dd.yiv6949709568last p span.yiv6949709568yshortcuts
{margin-right:0;}#yiv6949709568 div.yiv6949709568attach-table div div a
{text-decoration:none;}#yiv6949709568 div.yiv6949709568attach-table
{width:400px;}#yiv6949709568 div.yiv6949709568file-title a, #yiv6949709568
div.yiv6949709568file-title a:active, #yiv6949709568
div.yiv6949709568file-title a:hover, #yiv6949709568 div.yiv6949709568file-title
a:visited {text-decoration:none;}#yiv6949709568 div.yiv6949709568photo-title a,
#yiv6949709568 div.yiv6949709568photo-title a:active, #yiv6949709568
div.yiv6949709568photo-title a:hover, #yiv6949709568
div.yiv6949709568photo-title a:visited {text-decoration:none;}#yiv6949709568
div#yiv6949709568ygrp-mlmsg #yiv6949709568ygrp-msg p a
span.yiv6949709568yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6949709568
.yiv6949709568green {color:#628c2a;}#yiv6949709568 .yiv6949709568MsoNormal
{margin:0 0 0 0;}#yiv6949709568 o {font-size:0;}#yiv6949709568
#yiv6949709568photos div {float:left;width:72px;}#yiv6949709568
#yiv6949709568photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6949709568
#yiv6949709568photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6949709568
#yiv6949709568reco-category {font-size:77%;}#yiv6949709568
#yiv6949709568reco-desc {font-size:77%;}#yiv6949709568 .yiv6949709568replbq
{margin:4px;}#yiv6949709568 #yiv6949709568ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6949709568 #yiv6949709568ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6949709568
#yiv6949709568ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6949709568
#yiv6949709568ygrp-mlmsg select, #yiv6949709568 input, #yiv6949709568 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6949709568
#yiv6949709568ygrp-mlmsg pre, #yiv6949709568 code {font:115%
monospace;}#yiv6949709568 #yiv6949709568ygrp-mlmsg *
{line-height:1.22em;}#yiv6949709568 #yiv6949709568ygrp-mlmsg #yiv6949709568logo
{padding-bottom:10px;}#yiv6949709568 #yiv6949709568ygrp-msg p a
{font-family:Verdana;}#yiv6949709568 #yiv6949709568ygrp-msg
p#yiv6949709568attach-count span {color:#1E66AE;font-weight:700;}#yiv6949709568
#yiv6949709568ygrp-reco #yiv6949709568reco-head
{color:#ff7900;font-weight:700;}#yiv6949709568 #yiv6949709568ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6949709568 #yiv6949709568ygrp-sponsor
#yiv6949709568ov li a {font-size:130%;text-decoration:none;}#yiv6949709568
#yiv6949709568ygrp-sponsor #yiv6949709568ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6949709568
#yiv6949709568ygrp-sponsor #yiv6949709568ov ul {margin:0;padding:0 0 0
8px;}#yiv6949709568 #yiv6949709568ygrp-text
{font-family:Georgia;}#yiv6949709568 #yiv6949709568ygrp-text p {margin:0 0 1em
0;}#yiv6949709568 #yiv6949709568ygrp-text tt {font-size:120%;}#yiv6949709568
#yiv6949709568ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6949709568
