[belajar-excel] Digest Number 4038

Milis Belajar Microsoft Excel Group

4 Messages

Digest #4038

1a

Bls: [belajar-excel] BreakLink by "Toby kenzo" tobykenzo

1b

Re: BreakLink by "Dede Sulaeman"

2

Penjumlahan Beberapa Kriteria dalam 1 row by "Denny Oktavianus" denny_y86

3a

Bls: [belajar-excel] Lookup baris dan kolom by "Prodev SIMPLE PB" prodev_simple

Messages

1a

Bls: [belajar-excel] BreakLink

Wed Dec 7, 2016 2:51 am (PST) . Posted by:

"Toby kenzo" tobykenzo

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' dede_sulaeman@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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: belajar-excel@yahoogroups.com[mailto:belajar-excel@yahoogroups.com]
Sent: 07 Desember 2016 8:43
To: belajar-excel@yahoogroups.com
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

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Re: BreakLink

Wed Dec 7, 2016 5:07 pm (PST) . Posted by:

"Dede Sulaeman"

Dear Mr Toby,

Makasih atas masukannya, saya pelajari dulu.

Salam,

DD

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 07 Desember 2016 17:44
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] BreakLink

Dear DD,

Coba Script ini :

Dim a As Workbook
Dim b As Long
Dim c As Variant

Set a = ActiveWorkbook

c = a.LinkSources(Type:=xlLinkTypeExcelLinks)

For b = 1 To UBound(c)

a.BreakLink Name:=c(b), Type:=xlLinkTypeExcelLinks

Next b

Jika ada file link yang terprotect, maka tidak bisa nge-BreakLinks

TerimaKasih.

Pada Rabu, 7 Desember 2016 13:54, "'Dede Sulaeman' dede_sulaeman@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear BeExceller,

Berikut script yang 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").Move Before:=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: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 07 Desember 2016 8:43
To: belajar-excel@yahoogroups.com
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 mau nge-BreakLink "File A" tersebut.

Salam,

DD

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

2

Penjumlahan Beberapa Kriteria dalam 1 row

Wed Dec 7, 2016 8:52 pm (PST) . Posted by:

"Denny Oktavianus" denny_y86

dear all,
mohon di bantu kiranya bisa membantu untuk penjumlahan beberapa kriteria di dalam 1 row sesuai contoh ini.
terima kasih atas bantuannya .
denny

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3a

Bls: [belajar-excel] Lookup baris dan kolom

Thu Dec 8, 2016 12:01 am (PST) . Posted by:

"Prodev SIMPLE PB" prodev_simple

Assalamu'alaikum Wr. Wb.
Maaf ikut nimbrung di case ini... :)Mohon petunjuk, bagaimana cara memanfaatkan fitur DATA VALIDATION sehingga pada pemilihan GOL dan MASA KERJA bisa tinggal Klik Pilih (tidak ditulis manual).
Terima kasih atas penjelasannya.
Wassalam.
 - prodev simple -


Pada Senin, 28 November 2016 8:09, "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  thanks for your help mrs  eira

Pada Jumat, 25 November 2016 19:51, "Eira I Arie cheivory_bridge@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Cobain 
Semoga file terlampir sesuai harapan  ..

eira_arie

On Friday, November 25, 2016 8:05 PM, "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


   Yth. Bapak-Ibu member belajar excel group
mohon bantuan solusi untuk masalah kami, sesuai attach email berikut
demikian dan terima kasih

salam hormat

   cobain

#yiv2790644144 #yiv2790644144 -- #yiv2790644144ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2790644144 #yiv2790644144ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2790644144 #yiv2790644144ygrp-mkp #yiv2790644144hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2790644144 #yiv2790644144ygrp-mkp #yiv2790644144ads {margin-bottom:10px;}#yiv2790644144 #yiv2790644144ygrp-mkp .yiv2790644144ad {padding:0 0;}#yiv2790644144 #yiv2790644144ygrp-mkp .yiv2790644144ad p {margin:0;}#yiv2790644144 #yiv2790644144ygrp-mkp .yiv2790644144ad a {color:#0000ff;text-decoration:none;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ygrp-lc {font-family:Arial;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ygrp-lc #yiv2790644144hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ygrp-lc .yiv2790644144ad {margin-bottom:10px;padding:0 0;}#yiv2790644144 #yiv2790644144actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2790644144 #yiv2790644144activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2790644144 #yiv2790644144activity span {font-weight:700;}#yiv2790644144 #yiv2790644144activity span:first-child {text-transform:uppercase;}#yiv2790644144 #yiv2790644144activity span a {color:#5085b6;text-decoration:none;}#yiv2790644144 #yiv2790644144activity span span {color:#ff7900;}#yiv2790644144 #yiv2790644144activity span .yiv2790644144underline {text-decoration:underline;}#yiv2790644144 .yiv2790644144attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2790644144 .yiv2790644144attach div a {text-decoration:none;}#yiv2790644144 .yiv2790644144attach img {border:none;padding-right:5px;}#yiv2790644144 .yiv2790644144attach label {display:block;margin-bottom:5px;}#yiv2790644144 .yiv2790644144attach label a {text-decoration:none;}#yiv2790644144 blockquote {margin:0 0 0 4px;}#yiv2790644144 .yiv2790644144bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2790644144 .yiv2790644144bold a {text-decoration:none;}#yiv2790644144 dd.yiv2790644144last p a {font-family:Verdana;font-weight:700;}#yiv2790644144 dd.yiv2790644144last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2790644144 dd.yiv2790644144last p span.yiv2790644144yshortcuts {margin-right:0;}#yiv2790644144 div.yiv2790644144attach-table div div a {text-decoration:none;}#yiv2790644144 div.yiv2790644144attach-table {width:400px;}#yiv2790644144 div.yiv2790644144file-title a, #yiv2790644144 div.yiv2790644144file-title a:active, #yiv2790644144 div.yiv2790644144file-title a:hover, #yiv2790644144 div.yiv2790644144file-title a:visited {text-decoration:none;}#yiv2790644144 div.yiv2790644144photo-title a, #yiv2790644144 div.yiv2790644144photo-title a:active, #yiv2790644144 div.yiv2790644144photo-title a:hover, #yiv2790644144 div.yiv2790644144photo-title a:visited {text-decoration:none;}#yiv2790644144 div#yiv2790644144ygrp-mlmsg #yiv2790644144ygrp-msg p a span.yiv2790644144yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2790644144 .yiv2790644144green {color:#628c2a;}#yiv2790644144 .yiv2790644144MsoNormal {margin:0 0 0 0;}#yiv2790644144 o {font-size:0;}#yiv2790644144 #yiv2790644144photos div {float:left;width:72px;}#yiv2790644144 #yiv2790644144photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2790644144 #yiv2790644144photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2790644144 #yiv2790644144reco-category {font-size:77%;}#yiv2790644144 #yiv2790644144reco-desc {font-size:77%;}#yiv2790644144 .yiv2790644144replbq {margin:4px;}#yiv2790644144 #yiv2790644144ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2790644144 #yiv2790644144ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2790644144 #yiv2790644144ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2790644144 #yiv2790644144ygrp-mlmsg select, #yiv2790644144 input, #yiv2790644144 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2790644144 #yiv2790644144ygrp-mlmsg pre, #yiv2790644144 code {font:115% monospace;}#yiv2790644144 #yiv2790644144ygrp-mlmsg * {line-height:1.22em;}#yiv2790644144 #yiv2790644144ygrp-mlmsg #yiv2790644144logo {padding-bottom:10px;}#yiv2790644144 #yiv2790644144ygrp-msg p a {font-family:Verdana;}#yiv2790644144 #yiv2790644144ygrp-msg p#yiv2790644144attach-count span {color:#1E66AE;font-weight:700;}#yiv2790644144 #yiv2790644144ygrp-reco #yiv2790644144reco-head {color:#ff7900;font-weight:700;}#yiv2790644144 #yiv2790644144ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ov li a {font-size:130%;text-decoration:none;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2790644144 #yiv2790644144ygrp-sponsor #yiv2790644144ov ul {margin:0;padding:0 0 0 8px;}#yiv2790644144 #yiv2790644144ygrp-text {font-family:Georgia;}#yiv2790644144 #yiv2790644144ygrp-text p {margin:0 0 1em 0;}#yiv2790644144 #yiv2790644144ygrp-text tt {font-size:120%;}#yiv2790644144 #yiv2790644144ygrp-vital ul li:last-child {border-right:none !important;}#yiv2790644144

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use