Sdh dites....Thanks Mr. Kid Salam,HK Sent from Yahoo Mail on Android On Wed, Aug 2, 2017 at 5:58, 'Mr. Kid' [email protected] [belajar-excel]<[email protected]> wrote:
Jika memang file lokasi gabungan adalah di file yang berisi script VBA, maka ganti saja baris yang merujuk ke cells berisi tulisan nama file tersebut dengan ThisWorkbook. Kira-kira, kalau ada bunyi : blabla = Workbooks( rujukan_ke_cell_berisi_nama_file_master ) diubah menjadi : blabla = Thisworkbook Regards, Kid 2017-08-01 20:48 GMT+07:00 hendrik karnadi [email protected] [belajar-excel] <[email protected]>: Syukurlah.....Aslinya nama file "Master" dan nama folder dari file2 yang akan digabung ada di VBA....saya ganti ke Sheet spy lebih mudah. Salam,HK On Tuesday, August 1, 2017, 8:43:03 PM GMT+7, rodhy hakim [email protected] [belajar-excel] <[email protected] > wrote: Woowww.... terpecahkan....Terima kasih mr.kidBe exceler.... Dikirim dari iPhone saya Pada 30 Jul 2017, pukul 06.53, 'Mr. Kid' [email protected] [belajar-excel] <[email protected] > menulis: eh... dah selesai tritnya ? gitu doang ? ayoklah... gini... script yang ada di file dari pak HK itu (entah dapat darimana atau diubah apanya gak tau dah) tergantung suatu nilai referensi. referensi tersebut ada di sheet bernama 'sheet2' (nama sheet boleh diganti jadi lainnya). A1 : diisi nama file yang menggabungkan tersebut. Catatannya, buka windows explorer, lalu tulis nama file tersebut persis seperti yang ada di windows explorer. kalau di windows explorer tertulis bunyi 'Master.Kid', tulils di A1 bunyi 'Master.Kid' gitu... *** Ingat loh ya, script ini gak bisa nulis ke workbook lain, harus di workbook yang ada script-nya itu doang. Hasil gabungannya cuma di file itu juga. *** nama sheet yang ada tombol commandbutton nya jangan diganti jadi nama lainnya, harus 'sheet1' A2 : diisi nama folder files yang akan di-merge. lihat windows explorer lagi, masuk ke folder yang berisi files yang akan di-merge, lalu copy bunyi forlder yang ada di url bar nya, paste ke A2 *** pastikan isi foldernya cuma file yang akan di-merge. *** jangan ada file lainnya, apalagi file pilem iklan perusahaan yang gedenya sampai puluhan bahkan ratusan MB. Bisa dibuat cerewet tuh Excel oleh si script. tapi kalo cuma file jpg isinya gambar selfie yang dibawah 2MB sih boleh lah... sapa tahu mo lihat selfie-nya di Excel... bhuahahaha... Regards, Kid 2017-07-29 23:35 GMT+07:00 rodhy hakim [email protected] [belajar-excel] <[email protected] >: Dear Mr.HK,Kemungkinan tidak mau di drive C:Sy menggunakan laptop kantor yg hanya tersedia drive C: . Jadi harus bersabar krn gak bisa coba.... tapi terima kasih banyak atas bantuannya.... Salam odhy. Dikirim dari iPhone saya Pada 30 Jul 2017, pukul 00.05, hendrik karnadi [email protected] [belajar-excel] <[email protected] > menulis: Saya ganti jadi dir D:\CombineTestRev koq bisa jalan ya di komputer saya. Salam,HK Sent from Yahoo Mail on Android On Sat, Jul 29, 2017 at 15:09, Odhy [email protected] [belajar-excel]<[email protected] > wrote: Dear Mr. HK,Berikut Filenya... Terima Kasih atas pencerahannya, Odhy. On Saturday, July 29, 2017 11:03:04 AM WIB, hendrik karnadi [email protected] [belajar-excel] wrote: Dear Odhy, Coba kirim .zip dummy filenya. Salam,HK Sent from Yahoo Mail on Android #yiv7318435419 #yiv7318435419 -- #yiv7318435419ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7318435419 #yiv7318435419ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7318435419 #yiv7318435419ygrp-mkp #yiv7318435419hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7318435419 #yiv7318435419ygrp-mkp #yiv7318435419ads {margin-bottom:10px;}#yiv7318435419 #yiv7318435419ygrp-mkp .yiv7318435419ad {padding:0 0;}#yiv7318435419 #yiv7318435419ygrp-mkp .yiv7318435419ad p {margin:0;}#yiv7318435419 #yiv7318435419ygrp-mkp .yiv7318435419ad a {color:#0000ff;text-decoration:none;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ygrp-lc {font-family:Arial;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ygrp-lc #yiv7318435419hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ygrp-lc .yiv7318435419ad {margin-bottom:10px;padding:0 0;}#yiv7318435419 #yiv7318435419actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7318435419 #yiv7318435419activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7318435419 #yiv7318435419activity span {font-weight:700;}#yiv7318435419 #yiv7318435419activity span:first-child {text-transform:uppercase;}#yiv7318435419 #yiv7318435419activity span a {color:#5085b6;text-decoration:none;}#yiv7318435419 #yiv7318435419activity span span {color:#ff7900;}#yiv7318435419 #yiv7318435419activity span .yiv7318435419underline {text-decoration:underline;}#yiv7318435419 .yiv7318435419attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7318435419 .yiv7318435419attach div a {text-decoration:none;}#yiv7318435419 .yiv7318435419attach img {border:none;padding-right:5px;}#yiv7318435419 .yiv7318435419attach label {display:block;margin-bottom:5px;}#yiv7318435419 .yiv7318435419attach label a {text-decoration:none;}#yiv7318435419 blockquote {margin:0 0 0 4px;}#yiv7318435419 .yiv7318435419bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7318435419 .yiv7318435419bold a {text-decoration:none;}#yiv7318435419 dd.yiv7318435419last p a {font-family:Verdana;font-weight:700;}#yiv7318435419 dd.yiv7318435419last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7318435419 dd.yiv7318435419last p span.yiv7318435419yshortcuts {margin-right:0;}#yiv7318435419 div.yiv7318435419attach-table div div a {text-decoration:none;}#yiv7318435419 div.yiv7318435419attach-table {width:400px;}#yiv7318435419 div.yiv7318435419file-title a, #yiv7318435419 div.yiv7318435419file-title a:active, #yiv7318435419 div.yiv7318435419file-title a:hover, #yiv7318435419 div.yiv7318435419file-title a:visited {text-decoration:none;}#yiv7318435419 div.yiv7318435419photo-title a, #yiv7318435419 div.yiv7318435419photo-title a:active, #yiv7318435419 div.yiv7318435419photo-title a:hover, #yiv7318435419 div.yiv7318435419photo-title a:visited {text-decoration:none;}#yiv7318435419 div#yiv7318435419ygrp-mlmsg #yiv7318435419ygrp-msg p a span.yiv7318435419yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7318435419 .yiv7318435419green {color:#628c2a;}#yiv7318435419 .yiv7318435419MsoNormal {margin:0 0 0 0;}#yiv7318435419 o {font-size:0;}#yiv7318435419 #yiv7318435419photos div {float:left;width:72px;}#yiv7318435419 #yiv7318435419photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7318435419 #yiv7318435419photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7318435419 #yiv7318435419reco-category {font-size:77%;}#yiv7318435419 #yiv7318435419reco-desc {font-size:77%;}#yiv7318435419 .yiv7318435419replbq {margin:4px;}#yiv7318435419 #yiv7318435419ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7318435419 #yiv7318435419ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7318435419 #yiv7318435419ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7318435419 #yiv7318435419ygrp-mlmsg select, #yiv7318435419 input, #yiv7318435419 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7318435419 #yiv7318435419ygrp-mlmsg pre, #yiv7318435419 code {font:115% monospace;}#yiv7318435419 #yiv7318435419ygrp-mlmsg * {line-height:1.22em;}#yiv7318435419 #yiv7318435419ygrp-mlmsg #yiv7318435419logo {padding-bottom:10px;}#yiv7318435419 #yiv7318435419ygrp-msg p a {font-family:Verdana;}#yiv7318435419 #yiv7318435419ygrp-msg p#yiv7318435419attach-count span {color:#1E66AE;font-weight:700;}#yiv7318435419 #yiv7318435419ygrp-reco #yiv7318435419reco-head {color:#ff7900;font-weight:700;}#yiv7318435419 #yiv7318435419ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ov li a {font-size:130%;text-decoration:none;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7318435419 #yiv7318435419ygrp-sponsor #yiv7318435419ov ul {margin:0;padding:0 0 0 8px;}#yiv7318435419 #yiv7318435419ygrp-text {font-family:Georgia;}#yiv7318435419 #yiv7318435419ygrp-text p {margin:0 0 1em 0;}#yiv7318435419 #yiv7318435419ygrp-text tt {font-size:120%;}#yiv7318435419 #yiv7318435419ygrp-vital ul li:last-child {border-right:none !important;}#yiv7318435419
