Zip filenya hrs diextract dulu ke Dir D: Salam,HK Sent from Yahoo Mail on Android On Sat, Aug 4, 2018 at 21:47, farud duro [email protected] [belajar-excel]<[email protected]> wrote:
terimakasih bang hendrik jawabannya..tapi setelah dicoba ada debug d VBA-nya sperti foto dibawah Pada 4 Agustus 2018 18.31, hendrik karnadi [email protected] [belajar-excel] <[email protected]> menulis: Ini salah satu rujukan.Silakan extract lampiran berikut ke folder D:\Foto berupa Image bukan range.. Salam,HK On Saturday, 4 August 2018, 7:37:27 AM GMT+7, farud duro [email protected] [belajar-excel] <[email protected] > wrote: Assalamualaikum...untuk para master Excel semuanya saya mohon bantuannya bagaimana caranya agar bisa input foto secara otomatis yg ada dalam daftar sesuai namanya yang berada dalam folder.untuk lebih jelasnya saya kirim filenya.atas bantuannya saya sampaikan terimakasih #yiv8056746650 #yiv8056746650 -- #yiv8056746650ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8056746650 #yiv8056746650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8056746650 #yiv8056746650ygrp-mkp #yiv8056746650hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8056746650 #yiv8056746650ygrp-mkp #yiv8056746650ads {margin-bottom:10px;}#yiv8056746650 #yiv8056746650ygrp-mkp .yiv8056746650ad {padding:0 0;}#yiv8056746650 #yiv8056746650ygrp-mkp .yiv8056746650ad p {margin:0;}#yiv8056746650 #yiv8056746650ygrp-mkp .yiv8056746650ad a {color:#0000ff;text-decoration:none;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ygrp-lc {font-family:Arial;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ygrp-lc #yiv8056746650hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ygrp-lc .yiv8056746650ad {margin-bottom:10px;padding:0 0;}#yiv8056746650 #yiv8056746650actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8056746650 #yiv8056746650activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8056746650 #yiv8056746650activity span {font-weight:700;}#yiv8056746650 #yiv8056746650activity span:first-child {text-transform:uppercase;}#yiv8056746650 #yiv8056746650activity span a {color:#5085b6;text-decoration:none;}#yiv8056746650 #yiv8056746650activity span span {color:#ff7900;}#yiv8056746650 #yiv8056746650activity span .yiv8056746650underline {text-decoration:underline;}#yiv8056746650 .yiv8056746650attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8056746650 .yiv8056746650attach div a {text-decoration:none;}#yiv8056746650 .yiv8056746650attach img {border:none;padding-right:5px;}#yiv8056746650 .yiv8056746650attach label {display:block;margin-bottom:5px;}#yiv8056746650 .yiv8056746650attach label a {text-decoration:none;}#yiv8056746650 blockquote {margin:0 0 0 4px;}#yiv8056746650 .yiv8056746650bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8056746650 .yiv8056746650bold a {text-decoration:none;}#yiv8056746650 dd.yiv8056746650last p a {font-family:Verdana;font-weight:700;}#yiv8056746650 dd.yiv8056746650last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8056746650 dd.yiv8056746650last p span.yiv8056746650yshortcuts {margin-right:0;}#yiv8056746650 div.yiv8056746650attach-table div div a {text-decoration:none;}#yiv8056746650 div.yiv8056746650attach-table {width:400px;}#yiv8056746650 div.yiv8056746650file-title a, #yiv8056746650 div.yiv8056746650file-title a:active, #yiv8056746650 div.yiv8056746650file-title a:hover, #yiv8056746650 div.yiv8056746650file-title a:visited {text-decoration:none;}#yiv8056746650 div.yiv8056746650photo-title a, #yiv8056746650 div.yiv8056746650photo-title a:active, #yiv8056746650 div.yiv8056746650photo-title a:hover, #yiv8056746650 div.yiv8056746650photo-title a:visited {text-decoration:none;}#yiv8056746650 div#yiv8056746650ygrp-mlmsg #yiv8056746650ygrp-msg p a span.yiv8056746650yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8056746650 .yiv8056746650green {color:#628c2a;}#yiv8056746650 .yiv8056746650MsoNormal {margin:0 0 0 0;}#yiv8056746650 o {font-size:0;}#yiv8056746650 #yiv8056746650photos div {float:left;width:72px;}#yiv8056746650 #yiv8056746650photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8056746650 #yiv8056746650photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8056746650 #yiv8056746650reco-category {font-size:77%;}#yiv8056746650 #yiv8056746650reco-desc {font-size:77%;}#yiv8056746650 .yiv8056746650replbq {margin:4px;}#yiv8056746650 #yiv8056746650ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8056746650 #yiv8056746650ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8056746650 #yiv8056746650ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8056746650 #yiv8056746650ygrp-mlmsg select, #yiv8056746650 input, #yiv8056746650 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8056746650 #yiv8056746650ygrp-mlmsg pre, #yiv8056746650 code {font:115% monospace;}#yiv8056746650 #yiv8056746650ygrp-mlmsg * {line-height:1.22em;}#yiv8056746650 #yiv8056746650ygrp-mlmsg #yiv8056746650logo {padding-bottom:10px;}#yiv8056746650 #yiv8056746650ygrp-msg p a {font-family:Verdana;}#yiv8056746650 #yiv8056746650ygrp-msg p#yiv8056746650attach-count span {color:#1E66AE;font-weight:700;}#yiv8056746650 #yiv8056746650ygrp-reco #yiv8056746650reco-head {color:#ff7900;font-weight:700;}#yiv8056746650 #yiv8056746650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ov li a {font-size:130%;text-decoration:none;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8056746650 #yiv8056746650ygrp-sponsor #yiv8056746650ov ul {margin:0;padding:0 0 0 8px;}#yiv8056746650 #yiv8056746650ygrp-text {font-family:Georgia;}#yiv8056746650 #yiv8056746650ygrp-text p {margin:0 0 1em 0;}#yiv8056746650 #yiv8056746650ygrp-text tt {font-size:120%;}#yiv8056746650 #yiv8056746650ygrp-vital ul li:last-child {border-right:none !important;}#yiv8056746650
