Hai Ito,Coba file terlampir.
Salam,HK
Catatan :Setelah Down load file .rar nya....extract dulu ke suatu folder.
From: "Warsito Ito warsitoit...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 27 November 2015, 9:42
Subject: [belajar-excel] Mengambil data dari WB lain dengan Vba
Assalamualaikum...
Dear All
Saya mau minta bantuan dan pencerahan kepada para master,Cara mengambil data
dari workbook lain dengan Vba tanpa membuka workbook yang akan diambil datanya.
sebelumnya saya minta maaf bila pertanyaan terlalu singkat
Salam
ito
#yiv7676801911 #yiv7676801911 -- #yiv7676801911ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7676801911
#yiv7676801911ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7676801911
#yiv7676801911ygrp-mkp #yiv7676801911hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7676801911 #yiv7676801911ygrp-mkp #yiv7676801911ads
{margin-bottom:10px;}#yiv7676801911 #yiv7676801911ygrp-mkp .yiv7676801911ad
{padding:0 0;}#yiv7676801911 #yiv7676801911ygrp-mkp .yiv7676801911ad p
{margin:0;}#yiv7676801911 #yiv7676801911ygrp-mkp .yiv7676801911ad a
{color:#0000ff;text-decoration:none;}#yiv7676801911 #yiv7676801911ygrp-sponsor
#yiv7676801911ygrp-lc {font-family:Arial;}#yiv7676801911
#yiv7676801911ygrp-sponsor #yiv7676801911ygrp-lc #yiv7676801911hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7676801911
#yiv7676801911ygrp-sponsor #yiv7676801911ygrp-lc .yiv7676801911ad
{margin-bottom:10px;padding:0 0;}#yiv7676801911 #yiv7676801911actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7676801911
#yiv7676801911activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7676801911
#yiv7676801911activity span {font-weight:700;}#yiv7676801911
#yiv7676801911activity span:first-child
{text-transform:uppercase;}#yiv7676801911 #yiv7676801911activity span a
{color:#5085b6;text-decoration:none;}#yiv7676801911 #yiv7676801911activity span
span {color:#ff7900;}#yiv7676801911 #yiv7676801911activity span
.yiv7676801911underline {text-decoration:underline;}#yiv7676801911
.yiv7676801911attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7676801911 .yiv7676801911attach div a
{text-decoration:none;}#yiv7676801911 .yiv7676801911attach img
{border:none;padding-right:5px;}#yiv7676801911 .yiv7676801911attach label
{display:block;margin-bottom:5px;}#yiv7676801911 .yiv7676801911attach label a
{text-decoration:none;}#yiv7676801911 blockquote {margin:0 0 0
4px;}#yiv7676801911 .yiv7676801911bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7676801911
.yiv7676801911bold a {text-decoration:none;}#yiv7676801911 dd.yiv7676801911last
p a {font-family:Verdana;font-weight:700;}#yiv7676801911 dd.yiv7676801911last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7676801911
dd.yiv7676801911last p span.yiv7676801911yshortcuts
{margin-right:0;}#yiv7676801911 div.yiv7676801911attach-table div div a
{text-decoration:none;}#yiv7676801911 div.yiv7676801911attach-table
{width:400px;}#yiv7676801911 div.yiv7676801911file-title a, #yiv7676801911
div.yiv7676801911file-title a:active, #yiv7676801911
div.yiv7676801911file-title a:hover, #yiv7676801911 div.yiv7676801911file-title
a:visited {text-decoration:none;}#yiv7676801911 div.yiv7676801911photo-title a,
#yiv7676801911 div.yiv7676801911photo-title a:active, #yiv7676801911
div.yiv7676801911photo-title a:hover, #yiv7676801911
div.yiv7676801911photo-title a:visited {text-decoration:none;}#yiv7676801911
div#yiv7676801911ygrp-mlmsg #yiv7676801911ygrp-msg p a
span.yiv7676801911yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7676801911
.yiv7676801911green {color:#628c2a;}#yiv7676801911 .yiv7676801911MsoNormal
{margin:0 0 0 0;}#yiv7676801911 o {font-size:0;}#yiv7676801911
#yiv7676801911photos div {float:left;width:72px;}#yiv7676801911
#yiv7676801911photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7676801911
#yiv7676801911photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7676801911
#yiv7676801911reco-category {font-size:77%;}#yiv7676801911
#yiv7676801911reco-desc {font-size:77%;}#yiv7676801911 .yiv7676801911replbq
{margin:4px;}#yiv7676801911 #yiv7676801911ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7676801911 #yiv7676801911ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7676801911
#yiv7676801911ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7676801911
#yiv7676801911ygrp-mlmsg select, #yiv7676801911 input, #yiv7676801911 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7676801911
#yiv7676801911ygrp-mlmsg pre, #yiv7676801911 code {font:115%
monospace;}#yiv7676801911 #yiv7676801911ygrp-mlmsg *
{line-height:1.22em;}#yiv7676801911 #yiv7676801911ygrp-mlmsg #yiv7676801911logo
{padding-bottom:10px;}#yiv7676801911 #yiv7676801911ygrp-msg p a
{font-family:Verdana;}#yiv7676801911 #yiv7676801911ygrp-msg
p#yiv7676801911attach-count span {color:#1E66AE;font-weight:700;}#yiv7676801911
#yiv7676801911ygrp-reco #yiv7676801911reco-head
{color:#ff7900;font-weight:700;}#yiv7676801911 #yiv7676801911ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7676801911 #yiv7676801911ygrp-sponsor
#yiv7676801911ov li a {font-size:130%;text-decoration:none;}#yiv7676801911
#yiv7676801911ygrp-sponsor #yiv7676801911ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7676801911
#yiv7676801911ygrp-sponsor #yiv7676801911ov ul {margin:0;padding:0 0 0
8px;}#yiv7676801911 #yiv7676801911ygrp-text
{font-family:Georgia;}#yiv7676801911 #yiv7676801911ygrp-text p {margin:0 0 1em
0;}#yiv7676801911 #yiv7676801911ygrp-text tt {font-size:120%;}#yiv7676801911
#yiv7676801911ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7676801911
HK_Gabung Files (R).rar
Description: Binary data
