Selasa, 05 Januari 2016

[belajar-excel] Digest Number 3710

12 Messages

Digest #3710

Messages

Mon Jan 4, 2016 2:48 am (PST) . Posted by:

"Sumbodho"

Selamat siang BeExceller.

Saya mau menanyakan cara insert otomatis di excel dari foto yg ada di folder. Misal setiap di cell a2 diganti nama orng/barang maka di cell b6 gambar berubah sesuai a2.

Terima kasih tanggapannya.
Sumbodho

Mon Jan 4, 2016 7:05 am (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Hai Sumbodho,
Coba cari di arsip milis.
Seingat saya Mr. Kid dan mbak Siti pernah menjawab pertanyaan serupa.

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "Sumbodho tososan@rocketmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:04/01/2016 5:14 PM (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: [belajar-excel] Insert foto otomatis dari folder </div><div>
</div>Selamat siang BeExceller.

Saya mau menanyakan cara insert otomatis di excel dari foto yg ada di folder. Misal setiap di cell a2 diganti nama orng/barang maka di cell b6 gambar berubah sesuai a2.

Terima kasih tanggapannya.
Sumbodho

Mon Jan 4, 2016 10:20 pm (PST) . Posted by:

"sumbodho"

Terimakasih tanggapannya Bang HK,
saya pernah cari2 dan ketemu postingan dengan code2 spt ini

Private Sub Worksheet_Change(ByVal Target As Range)
Dim sFile As String, sPath As String
If Target.Count = 1 Then
If InStr(Target.Address & "|", "$C$3|") <> 0 Then
ActiveSheet.Calculate

'ganti rujukan path seperti contoh
'drive:\folder\subfolder\
'contoh : E:\myData\mySubData\
sPath = ThisWorkbook.Path & "\"
sFile = Range("c4").Value & ".jpg"
If LenB(Dir$(sPath & sFile)) <> 0 Then
imgPeserta.Picture = LoadPicture(sPath & sFile)
Else
imgPeserta.Picture = LoadPicture(vbNullString)
End If
End If
End If
End Sub

tapi terus terang saya masih bingung menerapkannnya, berikut ini saya
lampirkan file excel yang sy dapat dengan code di atas.

Realnya kala saya menempatkan foto2 dalam folder d:\foto peserta,
bagaimana mengimplementasikan dalam file dibawah ini.

Terimakasih
Sumbodho

On 1/4/2016 10:06 PM, Hendrik Karnadi hendrikkarnadi@yahoo.com
[belajar-excel] wrote:
> Hai Sumbodho,
> Coba cari di arsip milis.
> Seingat saya Mr. Kid dan mbak Siti pernah menjawab pertanyaan serupa.
>
> Salam,
> HK
>
> Sent from Samsung Mobile
>
>
> -------- Original message --------
> From: "Sumbodho tososan@rocketmail.com [belajar-excel]"
> Date:04/01/2016 5:14 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: [belajar-excel] Insert foto otomatis dari folder
>
> Selamat siang BeExceller.
>
> Saya mau menanyakan cara insert otomatis di excel dari foto yg ada di
> folder. Misal setiap di cell a2 diganti nama orng/barang maka di cell
> b6 gambar berubah sesuai a2.
>
> Terima kasih tanggapannya.
> Sumbodho
>
>

Mon Jan 4, 2016 9:31 am (PST) . Posted by:

mbellgedez

Selamat malam pak...
Mohon saya di invite juga buat belajar macro & vba..
Abdoel khobir Glendoch@gmail.com

Sent from my iPad

> On Dec 24, 2015, at 12:40 PM, Indra muhammad indriadi indra.muhamad@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
> Pak HK,
> Invite email sy jg doank indra.muhamad@yahoo.com, nambah ilmu makro & vba‎..sblmnya terima kasih
>
>
> From: hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]
> Sent: Kamis, 24 Desember 2015 11.04
> To: belajar-excel@yahoogroups.com
> Reply To: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Hai Ruswanto,
> Sdh diinvite.
>
> Salam,

> HK
>
>
>
> From: "rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> To: belajar-excel@yahoogroups.com
> Sent: Wednesday, 23 December 2015, 13:02
> Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Kepada yth
> Bp. HK
> Mohon kiranya diinvite email saya..pengen belajar macro VBA.
> rwanto78@yahoo.com
>
> Terimakasih sebelumnya
>
> Salam hormat
> Ruswanto
> Powered by Telkomsel BlackBerry®
> From: "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> Sender: belajar-excel@yahoogroups.com
> Date: Wed, 23 Dec 2015 04:43:41 +0000 (UTC)
> To: <belajar-excel@yahoogroups.com>
> ReplyTo: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro VBA
>
>

> Dear Pak HK,
>
> Saya juga mau dong.
>
> Regards,
> Wahyu
>
>
>
>
> On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Hallo Pak Hendrik,
> Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.
>
> Terima kasih.
>
> Email : tio.adjie@ptssb.co.id
>
>
> From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
> Sent: Tuesday, December 22, 2015 10:38 PM
> To: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA
>

>
> Hai Haris,
> Sdh saya invite.
>
> Salam,
> HK
>
>
> Sent from Samsung Mobile
>
> -------- Original message --------
> From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]"
> Date:22/12/2015 5:26 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: Bls: [belajar-excel] Belajar Makro VBA
>
>
> saya juga mau belajar Makro & VBA sungguh :)
>
> Pada Selasa, 22 Desember 2015 13:56, "ris ha har1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
> Dear Pak Hendrik
>
> Saya juga ingein belajar menggunakan makro. har1sn.excel@yahoo.com
>
> salam
> Haris
>
> On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>

>
> Dear Pak Hendrik
>
> Bolehkan di invited email Saya ?
> Saya juga ingein belajar menggunakan makro.
>
> Wassalam
>
>
>
>
>
>
>
>
>

Mon Jan 4, 2016 4:04 pm (PST) . Posted by:

"Denny" denny_y86

Jika berkenan saya juga mau belajar makro dan vba.

Terima kasih

Salam

Denny

> On Dec 24, 2015, at 11:05, rwanto78@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
> Tks om hendrik
>
> Powered by Telkomsel BlackBerry®
> From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> Sender: belajar-excel@yahoogroups.com
> Date: Thu, 24 Dec 2015 04:01:25 +0000 (UTC)
> To: belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>
> ReplyTo: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro VBA
>
>
> Hai Ruswanto,
> Sdh diinvite.
>
> Salam,
> HK
>
>
>
> From: "rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> To: belajar-excel@yahoogroups.com
> Sent: Wednesday, 23 December 2015, 13:02
> Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Kepada yth
> Bp. HK
> Mohon kiranya diinvite email saya..pengen belajar macro VBA.
> rwanto78@yahoo.com
>
> Terimakasih sebelumnya
>
> Salam hormat
> Ruswanto
> Powered by Telkomsel BlackBerry®
> From: "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> Sender: belajar-excel@yahoogroups.com
> Date: Wed, 23 Dec 2015 04:43:41 +0000 (UTC)
> To: <belajar-excel@yahoogroups.com>
> ReplyTo: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro VBA
>
>
> Dear Pak HK,
>
> Saya juga mau dong.
>
> Regards,
> Wahyu
>
>
>
>
> On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Hallo Pak Hendrik,
> Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.
>
> Terima kasih.
>
> Email : tio.adjie@ptssb.co.id
>
>
> From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
> Sent: Tuesday, December 22, 2015 10:38 PM
> To: belajar-excel@yahoogroups.com
> Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Hai Haris,
> Sdh saya invite.
>
> Salam,
> HK
>
>
> Sent from Samsung Mobile
>
> -------- Original message --------
> From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]"
> Date:22/12/2015 5:26 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: Bls: [belajar-excel] Belajar Makro VBA
>
>
> saya juga mau belajar Makro & VBA sungguh :)
>
> Pada Selasa, 22 Desember 2015 13:56, "ris ha har1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
> Dear Pak Hendrik
>
> Saya juga ingein belajar menggunakan makro. har1sn.excel@yahoo.com
>
> salam
> Haris
>
> On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
> Dear Pak Hendrik
>
> Bolehkan di invited email Saya ?
> Saya juga ingein belajar menggunakan makro.
>
> Wassalam
>
>
>
>
>
>
>

Mon Jan 4, 2016 5:51 pm (PST) . Posted by:

"Samsudin"

Dear Master Excel,

Saya juga ingin ikutan juga belajara makro & vba itupun jika Master berkenan

Terima kasih
Samsudin

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, January 05, 2016 7:43 AM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA


Jika berkenan saya juga mau belajar makro dan vba.

Terima kasih

Salam

Denny

On Dec 24, 2015, at 11:05, rwanto78@yahoo.com<mailto:rwanto78@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote:


Tks om hendrik
Powered by Telkomsel BlackBerry®
________________________________
From: "hendrik karnadi hendrikkarnadi@yahoo.com<mailto:hendrikkarnadi@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
Sender: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Date: Thu, 24 Dec 2015 04:01:25 +0000 (UTC)
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com><belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
ReplyTo: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: Bls: [belajar-excel] Belajar Makro VBA


Hai Ruswanto,
Sdh diinvite.

Salam,
HK


________________________________
From: "rwanto78@yahoo.com<mailto:rwanto78@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Sent: Wednesday, 23 December 2015, 13:02
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA


Kepada yth
Bp. HK
Mohon kiranya diinvite email saya..pengen belajar macro VBA.
rwanto78@yahoo.com<mailto:rwanto78@yahoo.com>

Terimakasih sebelumnya

Salam hormat
Ruswanto
Powered by Telkomsel BlackBerry®
________________________________
From: "wahyu abdi wahyu71@yahoo.com<mailto:wahyu71@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
Sender: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Date: Wed, 23 Dec 2015 04:43:41 +0000 (UTC)
To: <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
ReplyTo: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: Bls: [belajar-excel] Belajar Makro VBA


Dear Pak HK,

Saya juga mau dong.

Regards,
Wahyu


On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id<mailto:tio.adjie@ptssb.co.id> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote:


Hallo Pak Hendrik,
Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.

Terima kasih.

Email : tio.adjie@ptssb.co.id<mailto:stefany.muller@ptssb.co.id>





From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA


Hai Haris,
Sdh saya invite.

Salam,
HK


Sent from Samsung Mobile

-------- Original message --------
From: "Rian Sutarsa riansutarsa@yahoo.com<mailto:riansutarsa@yahoo.com> [belajar-excel]"
Date:22/12/2015 5:26 PM (GMT+07:00)
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Bls: [belajar-excel] Belajar Makro VBA


saya juga mau belajar Makro & VBA sungguh :)

Pada Selasa, 22 Desember 2015 13:56, "ris ha har1sn.excel@yahoo.com<mailto:har1sn.excel@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> menulis:


Dear Pak Hendrik

Saya juga ingein belajar menggunakan makro. har1sn.excel@yahoo.com<mailto:har1sn.excel@yahoo.com>

salam
Haris

On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]<mailto:rudhiedhie@yahoo.com%20[belajar-excel]>" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote:


Dear Pak Hendrik

Bolehkan di invited email Saya ?
Saya juga ingein belajar menggunakan makro.

Wassalam






----------------------------------------------------------

This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.

Mon Jan 4, 2016 6:44 pm (PST) . Posted by:

"Ryan Sacth" ryan_sacth

Saya juga mw belajar VBA-Macro.Mohon di Invite, ryan_sacth@ymail.com

On Tuesday, January 5, 2016 9:05 AM, "Denny denny_y86@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Jika berkenan saya juga mau belajar makro dan vba.
Terima kasih
Salam
Denny
On Dec 24, 2015, at 11:05, rwanto78@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  Tks om hendrikPowered by Telkomsel BlackBerry®From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>Sender: belajar-excel@yahoogroups.comDate: Thu, 24 Dec 2015 04:01:25 +0000 (UTC)To: belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>ReplyTo: belajar-excel@yahoogroups.comSubject: Re: Bls: [belajar-excel] Belajar Makro VBA
  Hai Ruswanto,Sdh diinvite.
Salam,HK


From: "rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 23 December 2015, 13:02
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA

  Kepada yth
Bp. HK
Mohon kiranya diinvite email saya..pengen belajar macro VBA.
rwanto78@yahoo.com

Terimakasih sebelumnya

Salam hormat
RuswantoPowered by Telkomsel BlackBerry®From: "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>Sender: belajar-excel@yahoogroups.comDate: Wed, 23 Dec 2015 04:43:41 +0000 (UTC)To: <belajar-excel@yahoogroups.com>ReplyTo: belajar-excel@yahoogroups.comSubject: Re: Bls: [belajar-excel] Belajar Makro VBA
  Dear Pak HK,
Saya juga mau dong.
Regards,Wahyu

On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Hallo Pak Hendrik, Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.   Terima kasih.  
| Email :tio.adjie@ptssb.co.id | |
| | | |
| | | | |

    From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Haris, Sdh saya invite.   Salam, HK     Sent from Samsung Mobile   -------- Original message -------- From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]" Date:22/12/2015 5:26 PM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Belajar Makro VBA     saya juga mau belajar Makro & VBA sungguh :)   Pada Selasa, 22 Desember 2015 13:56, "ris hahar1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:     Dear Pak Hendrik   Saya juga ingein belajar menggunakan makro.har1sn.excel@yahoo.com   salam Haris   On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:     Dear Pak Hendrik   Bolehkan di invited email Saya ? Saya juga ingein belajar menggunakan makro.   Wassalam    

#yiv6827394767 #yiv6827394767 -- #yiv6827394767ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6827394767 #yiv6827394767ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6827394767 #yiv6827394767ygrp-mkp #yiv6827394767hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6827394767 #yiv6827394767ygrp-mkp #yiv6827394767ads {margin-bottom:10px;}#yiv6827394767 #yiv6827394767ygrp-mkp .yiv6827394767ad {padding:0 0;}#yiv6827394767 #yiv6827394767ygrp-mkp .yiv6827394767ad p {margin:0;}#yiv6827394767 #yiv6827394767ygrp-mkp .yiv6827394767ad a {color:#0000ff;text-decoration:none;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ygrp-lc {font-family:Arial;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ygrp-lc #yiv6827394767hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ygrp-lc .yiv6827394767ad {margin-bottom:10px;padding:0 0;}#yiv6827394767 #yiv6827394767actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6827394767 #yiv6827394767activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6827394767 #yiv6827394767activity span {font-weight:700;}#yiv6827394767 #yiv6827394767activity span:first-child {text-transform:uppercase;}#yiv6827394767 #yiv6827394767activity span a {color:#5085b6;text-decoration:none;}#yiv6827394767 #yiv6827394767activity span span {color:#ff7900;}#yiv6827394767 #yiv6827394767activity span .yiv6827394767underline {text-decoration:underline;}#yiv6827394767 .yiv6827394767attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6827394767 .yiv6827394767attach div a {text-decoration:none;}#yiv6827394767 .yiv6827394767attach img {border:none;padding-right:5px;}#yiv6827394767 .yiv6827394767attach label {display:block;margin-bottom:5px;}#yiv6827394767 .yiv6827394767attach label a {text-decoration:none;}#yiv6827394767 blockquote {margin:0 0 0 4px;}#yiv6827394767 .yiv6827394767bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6827394767 .yiv6827394767bold a {text-decoration:none;}#yiv6827394767 dd.yiv6827394767last p a {font-family:Verdana;font-weight:700;}#yiv6827394767 dd.yiv6827394767last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6827394767 dd.yiv6827394767last p span.yiv6827394767yshortcuts {margin-right:0;}#yiv6827394767 div.yiv6827394767attach-table div div a {text-decoration:none;}#yiv6827394767 div.yiv6827394767attach-table {width:400px;}#yiv6827394767 div.yiv6827394767file-title a, #yiv6827394767 div.yiv6827394767file-title a:active, #yiv6827394767 div.yiv6827394767file-title a:hover, #yiv6827394767 div.yiv6827394767file-title a:visited {text-decoration:none;}#yiv6827394767 div.yiv6827394767photo-title a, #yiv6827394767 div.yiv6827394767photo-title a:active, #yiv6827394767 div.yiv6827394767photo-title a:hover, #yiv6827394767 div.yiv6827394767photo-title a:visited {text-decoration:none;}#yiv6827394767 div#yiv6827394767ygrp-mlmsg #yiv6827394767ygrp-msg p a span.yiv6827394767yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6827394767 .yiv6827394767green {color:#628c2a;}#yiv6827394767 .yiv6827394767MsoNormal {margin:0 0 0 0;}#yiv6827394767 o {font-size:0;}#yiv6827394767 #yiv6827394767photos div {float:left;width:72px;}#yiv6827394767 #yiv6827394767photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6827394767 #yiv6827394767photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6827394767 #yiv6827394767reco-category {font-size:77%;}#yiv6827394767 #yiv6827394767reco-desc {font-size:77%;}#yiv6827394767 .yiv6827394767replbq {margin:4px;}#yiv6827394767 #yiv6827394767ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6827394767 #yiv6827394767ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6827394767 #yiv6827394767ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6827394767 #yiv6827394767ygrp-mlmsg select, #yiv6827394767 input, #yiv6827394767 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6827394767 #yiv6827394767ygrp-mlmsg pre, #yiv6827394767 code {font:115% monospace;}#yiv6827394767 #yiv6827394767ygrp-mlmsg * {line-height:1.22em;}#yiv6827394767 #yiv6827394767ygrp-mlmsg #yiv6827394767logo {padding-bottom:10px;}#yiv6827394767 #yiv6827394767ygrp-msg p a {font-family:Verdana;}#yiv6827394767 #yiv6827394767ygrp-msg p#yiv6827394767attach-count span {color:#1E66AE;font-weight:700;}#yiv6827394767 #yiv6827394767ygrp-reco #yiv6827394767reco-head {color:#ff7900;font-weight:700;}#yiv6827394767 #yiv6827394767ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ov li a {font-size:130%;text-decoration:none;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6827394767 #yiv6827394767ygrp-sponsor #yiv6827394767ov ul {margin:0;padding:0 0 0 8px;}#yiv6827394767 #yiv6827394767ygrp-text {font-family:Georgia;}#yiv6827394767 #yiv6827394767ygrp-text p {margin:0 0 1em 0;}#yiv6827394767 #yiv6827394767ygrp-text tt {font-size:120%;}#yiv6827394767 #yiv6827394767ygrp-vital ul li:last-child {border-right:none !important;}#yiv6827394767

Tue Jan 5, 2016 12:55 am (PST) . Posted by:

"Kamto, Tukino"

saya juga ya Pak. Kalau memungkinkan dari yang paliiing dasar.

Nuwun

On 5 January 2016 at 08:42, Ryan Sacth ryan_sacth@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:

>
>
> Saya juga mw belajar VBA-Macro.
> Mohon di Invite, ryan_sacth@ymail.com
>
>
> On Tuesday, January 5, 2016 9:05 AM, "Denny denny_y86@yahoo.co.id
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Jika berkenan saya juga mau belajar makro dan vba.
>
> Terima kasih
>
> Salam
>
> Denny
>
> On Dec 24, 2015, at 11:05, rwanto78@yahoo.com [belajar-excel] <
> belajar-excel@yahoogroups.com> wrote:
>

>
> Tks om hendrik
> Powered by Telkomsel BlackBerry®
> ------------------------------
> *From: * "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *Sender: * belajar-excel@yahoogroups.com
> *Date: *Thu, 24 Dec 2015 04:01:25 +0000 (UTC)
> *To: *belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>
> *ReplyTo: * belajar-excel@yahoogroups.com
> *Subject: *Re: Bls: [belajar-excel] Belajar Makro VBA
>
>
> Hai Ruswanto,
> Sdh diinvite.
>
> Salam,
> HK
>
>
>
> ------------------------------
> *From:* "rwanto78@yahoo.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *To:* belajar-excel@yahoogroups.com
> *Sent:* Wednesday, 23 December 2015, 13:02
> *Subject:* Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Kepada yth
> Bp. HK
> Mohon kiranya diinvite email saya..pengen belajar macro VBA.
> rwanto78@yahoo.com
>
> Terimakasih sebelumnya
>
> Salam hormat
> Ruswanto
> Powered by Telkomsel BlackBerry®
> ------------------------------
> *From: * "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *Sender: * belajar-excel@yahoogroups.com
> *Date: *Wed, 23 Dec 2015 04:43:41 +0000 (UTC)
> *To: *<belajar-excel@yahoogroups.com>
> *ReplyTo: * belajar-excel@yahoogroups.com
> *Subject: *Re: Bls: [belajar-excel] Belajar Makro VBA
>
>
> Dear Pak HK,
>
> Saya juga mau dong.
>
> Regards,
> Wahyu
>
>
>
>
> On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie
> tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
> wrote:
>
>
>
> Hallo Pak Hendrik,
> Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.
>
> Terima kasih.
>
> *Email : **tio.adjie@ptssb.co.id <stefany.muller@ptssb.co.id>*
>
>
> *From:* belajar-excel@yahoogroups.com [
> mailto:belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>]
> *Sent:* Tuesday, December 22, 2015 10:38 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: Bls: [belajar-excel] Belajar Makro & VBA
>
>
> Hai Haris,
> Sdh saya invite.
>
> Salam,
> HK
>
>
> Sent from Samsung Mobile
>
> -------- Original message --------
> From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]"
> Date:22/12/2015 5:26 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: Bls: [belajar-excel] Belajar Makro VBA
>
>
> saya juga mau belajar Makro & VBA sungguh :)
>
> Pada Selasa, 22 Desember 2015 13:56, "ris ha har1sn.excel@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
> Dear Pak Hendrik
>
> Saya juga ingein belajar menggunakan makro. har1sn.excel@yahoo.com
>
> salam
> Haris
>
> On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
> Dear Pak Hendrik
>
> Bolehkan di invited email Saya ?
> Saya juga ingein belajar menggunakan makro.
>
> Wassalam
>
>
>
>
>
>
>
>
>
>

Mon Jan 4, 2016 10:21 pm (PST) . Posted by:

"Warsito Ito" warsitoito14

Kepada para master yang baik hati,..
Sya punya file excel vba yang di share lewat homegroup,dan ada satu komputer yang tidak bisa membuka nya

error dengan peringatan Compile error pada

lwaktu.caption = FormatDateTime(Time, vbLongTime)
ltanggal.Caption = Format(Date, "dddd,dd mmmm yyyy")
semoga para master bisa memberikan solusinya

Terima kasih

Ito

Mon Jan 4, 2016 11:07 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Apakah CurrentRegion di Komputer ini Indonesian ?Kalau ya, coba ganti Englsih US.
Salam,HK


From: "Warsito Ito warsitoito14@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 5 January 2016, 12:57
Subject: [belajar-excel] File VBA Error

  Kepada para master yang baik hati,..
Sya punya file excel vba yang di share lewat homegroup,dan ada satu komputer yang tidak bisa membuka nya

error dengan peringatan Compile error pada

lwaktu.caption = FormatDateTime(Time, vbLongTime)
ltanggal.Caption = Format(Date, "dddd,dd mmmm yyyy")
semoga para master bisa memberikan solusinya

Terima kasih

Ito
#yiv5598498244 #yiv5598498244 -- #yiv5598498244ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5598498244 #yiv5598498244ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5598498244 #yiv5598498244ygrp-mkp #yiv5598498244hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5598498244 #yiv5598498244ygrp-mkp #yiv5598498244ads {margin-bottom:10px;}#yiv5598498244 #yiv5598498244ygrp-mkp .yiv5598498244ad {padding:0 0;}#yiv5598498244 #yiv5598498244ygrp-mkp .yiv5598498244ad p {margin:0;}#yiv5598498244 #yiv5598498244ygrp-mkp .yiv5598498244ad a {color:#0000ff;text-decoration:none;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ygrp-lc {font-family:Arial;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ygrp-lc #yiv5598498244hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ygrp-lc .yiv5598498244ad {margin-bottom:10px;padding:0 0;}#yiv5598498244 #yiv5598498244actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5598498244 #yiv5598498244activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5598498244 #yiv5598498244activity span {font-weight:700;}#yiv5598498244 #yiv5598498244activity span:first-child {text-transform:uppercase;}#yiv5598498244 #yiv5598498244activity span a {color:#5085b6;text-decoration:none;}#yiv5598498244 #yiv5598498244activity span span {color:#ff7900;}#yiv5598498244 #yiv5598498244activity span .yiv5598498244underline {text-decoration:underline;}#yiv5598498244 .yiv5598498244attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5598498244 .yiv5598498244attach div a {text-decoration:none;}#yiv5598498244 .yiv5598498244attach img {border:none;padding-right:5px;}#yiv5598498244 .yiv5598498244attach label {display:block;margin-bottom:5px;}#yiv5598498244 .yiv5598498244attach label a {text-decoration:none;}#yiv5598498244 blockquote {margin:0 0 0 4px;}#yiv5598498244 .yiv5598498244bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5598498244 .yiv5598498244bold a {text-decoration:none;}#yiv5598498244 dd.yiv5598498244last p a {font-family:Verdana;font-weight:700;}#yiv5598498244 dd.yiv5598498244last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5598498244 dd.yiv5598498244last p span.yiv5598498244yshortcuts {margin-right:0;}#yiv5598498244 div.yiv5598498244attach-table div div a {text-decoration:none;}#yiv5598498244 div.yiv5598498244attach-table {width:400px;}#yiv5598498244 div.yiv5598498244file-title a, #yiv5598498244 div.yiv5598498244file-title a:active, #yiv5598498244 div.yiv5598498244file-title a:hover, #yiv5598498244 div.yiv5598498244file-title a:visited {text-decoration:none;}#yiv5598498244 div.yiv5598498244photo-title a, #yiv5598498244 div.yiv5598498244photo-title a:active, #yiv5598498244 div.yiv5598498244photo-title a:hover, #yiv5598498244 div.yiv5598498244photo-title a:visited {text-decoration:none;}#yiv5598498244 div#yiv5598498244ygrp-mlmsg #yiv5598498244ygrp-msg p a span.yiv5598498244yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5598498244 .yiv5598498244green {color:#628c2a;}#yiv5598498244 .yiv5598498244MsoNormal {margin:0 0 0 0;}#yiv5598498244 o {font-size:0;}#yiv5598498244 #yiv5598498244photos div {float:left;width:72px;}#yiv5598498244 #yiv5598498244photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5598498244 #yiv5598498244photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5598498244 #yiv5598498244reco-category {font-size:77%;}#yiv5598498244 #yiv5598498244reco-desc {font-size:77%;}#yiv5598498244 .yiv5598498244replbq {margin:4px;}#yiv5598498244 #yiv5598498244ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5598498244 #yiv5598498244ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5598498244 #yiv5598498244ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5598498244 #yiv5598498244ygrp-mlmsg select, #yiv5598498244 input, #yiv5598498244 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5598498244 #yiv5598498244ygrp-mlmsg pre, #yiv5598498244 code {font:115% monospace;}#yiv5598498244 #yiv5598498244ygrp-mlmsg * {line-height:1.22em;}#yiv5598498244 #yiv5598498244ygrp-mlmsg #yiv5598498244logo {padding-bottom:10px;}#yiv5598498244 #yiv5598498244ygrp-msg p a {font-family:Verdana;}#yiv5598498244 #yiv5598498244ygrp-msg p#yiv5598498244attach-count span {color:#1E66AE;font-weight:700;}#yiv5598498244 #yiv5598498244ygrp-reco #yiv5598498244reco-head {color:#ff7900;font-weight:700;}#yiv5598498244 #yiv5598498244ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ov li a {font-size:130%;text-decoration:none;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5598498244 #yiv5598498244ygrp-sponsor #yiv5598498244ov ul {margin:0;padding:0 0 0 8px;}#yiv5598498244 #yiv5598498244ygrp-text {font-family:Georgia;}#yiv5598498244 #yiv5598498244ygrp-text p {margin:0 0 1em 0;}#yiv5598498244 #yiv5598498244ygrp-text tt {font-size:120%;}#yiv5598498244 #yiv5598498244ygrp-vital ul li:last-child {border-right:none !important;}#yiv5598498244

Mon Jan 4, 2016 11:02 pm (PST) . Posted by:

"Toby kenzo" tobykenzo


--------------------------------------------
Pada Sel, 5/1/16, sumbodho tososan@rocketmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] Insert foto otomatis dari folder [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 5 Januari, 2016, 12:34 PM


 
Dear Sumbodho,

Pada sPath = ThisWorkbook.Path &"\" di ganti folder rujukan dimana tempatnya foto2 tersebut, misal seperti yang anda sebutkan foto2 tersebut ada di folder: d:\foto peserta,

maka:

sPath = ThisWorkbook.Path &"\" di ganti jadi :
sPath = "d:\foto peserta" &"\"

terus:

sFile = Range("c4").Value & ".jpg" adalah nama file (foto name) orangnya(peserta), tapi perlu di ingat fotonya yang format "JPG".
kalo formatnya lain (bukan JPG) missal BMP

maka:

sFile = Range("c4").Value & ".jpg" digant jadi:
sFile = Range("c4").Value & ".BMP"

Semoga bisa membantu

TerimaKasih.








Terimakasih tanggapannya Bang HK,

saya pernah cari2 dan ketemu postingan dengan code2 spt
ini



Private Sub Worksheet_Change(ByVal Target As Range)

    Dim sFile As String, sPath As String

    If Target.Count = 1 Then

        If InStr(Target.Address &
"|", "$C$3|") <> 0 Then

            ActiveSheet.Calculate

               

            'ganti rujukan path seperti
contoh

           
'drive:\folder\subfolder\

            'contoh :
E:\myData\mySubData\

            sPath = ThisWorkbook.Path &
"\"

            sFile =
Range("c4").Value & ".jpg"

            If LenB(Dir$(sPath & sFile))
<> 0 Then

                imgPeserta.Picture =
LoadPicture(sPath & sFile)

            Else

                imgPeserta.Picture =
LoadPicture(vbNullString)

            End If

        End If

    End If

End Sub



tapi terus terang saya masih bingung menerapkannnya,
berikut ini
saya lampirkan file excel yang sy dapat dengan code di
atas. 



Realnya  kala saya menempatkan foto2 dalam folder
d:\foto peserta,
bagaimana mengimplementasikan dalam file dibawah ini.


 

Terimakasih

Sumbodho







On
1/4/2016 10:06 PM, Hendrik Karnadi
hendrikkarnadi@yahoo.com
[belajar-excel] wrote:


 


Hai Sumbodho,
Coba cari di arsip milis.
Seingat saya Mr. Kid dan mbak Siti pernah
menjawab
pertanyaan serupa.



Salam,
HK




Sent from
Samsung Mobile





-------- Original message --------
From: "Sumbodho tososan@rocketmail.com
[belajar-excel]"

Date:04/01/2016 5:14 PM (GMT+07:00)
To: belajar-excel@yahoogroups.com

Subject: [belajar-excel] Insert foto
otomatis dari
folder



 

Selamat siang BeExceller.



Saya mau menanyakan cara insert otomatis di
excel dari
foto yg ada di folder. Misal setiap di cell
a2 diganti
nama orng/barang maka di cell b6 gambar
berubah sesuai
a2.



Terima kasih tanggapannya.

Sumbodho























#yiv3579788207 #yiv3579788207 --
#yiv3579788207ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv3579788207 #yiv3579788207ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3579788207 #yiv3579788207ygrp-mkp #yiv3579788207hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3579788207 #yiv3579788207ygrp-mkp #yiv3579788207ads {
margin-bottom:10px;}

#yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad {
padding:0 0;}

#yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad p {
margin:0;}

#yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad a {
color:#0000ff;text-decoration:none;}
#yiv3579788207 #yiv3579788207ygrp-sponsor
#yiv3579788207ygrp-lc {
font-family:Arial;}

#yiv3579788207 #yiv3579788207ygrp-sponsor
#yiv3579788207ygrp-lc #yiv3579788207hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3579788207 #yiv3579788207ygrp-sponsor
#yiv3579788207ygrp-lc .yiv3579788207ad {
margin-bottom:10px;padding:0 0;}

#yiv3579788207 #yiv3579788207actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv3579788207 #yiv3579788207activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv3579788207 #yiv3579788207activity span {
font-weight:700;}

#yiv3579788207 #yiv3579788207activity span:first-child {
text-transform:uppercase;}

#yiv3579788207 #yiv3579788207activity span a {
color:#5085b6;text-decoration:none;}

#yiv3579788207 #yiv3579788207activity span span {
color:#ff7900;}

#yiv3579788207 #yiv3579788207activity span
.yiv3579788207underline {
text-decoration:underline;}

#yiv3579788207 .yiv3579788207attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv3579788207 .yiv3579788207attach div a {
text-decoration:none;}

#yiv3579788207 .yiv3579788207attach img {
border:none;padding-right:5px;}

#yiv3579788207 .yiv3579788207attach label {
display:block;margin-bottom:5px;}

#yiv3579788207 .yiv3579788207attach label a {
text-decoration:none;}

#yiv3579788207 blockquote {
margin:0 0 0 4px;}

#yiv3579788207 .yiv3579788207bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3579788207 .yiv3579788207bold a {
text-decoration:none;}

#yiv3579788207 dd.yiv3579788207last p a {
font-family:Verdana;font-weight:700;}

#yiv3579788207 dd.yiv3579788207last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv3579788207 dd.yiv3579788207last p
span.yiv3579788207yshortcuts {
margin-right:0;}

#yiv3579788207 div.yiv3579788207attach-table div div a {
text-decoration:none;}

#yiv3579788207 div.yiv3579788207attach-table {
width:400px;}

#yiv3579788207 div.yiv3579788207file-title a, #yiv3579788207
div.yiv3579788207file-title a:active, #yiv3579788207
div.yiv3579788207file-title a:hover, #yiv3579788207
div.yiv3579788207file-title a:visited {
text-decoration:none;}

#yiv3579788207 div.yiv3579788207photo-title a,
#yiv3579788207 div.yiv3579788207photo-title a:active,
#yiv3579788207 div.yiv3579788207photo-title a:hover,
#yiv3579788207 div.yiv3579788207photo-title a:visited {
text-decoration:none;}

#yiv3579788207 div#yiv3579788207ygrp-mlmsg
#yiv3579788207ygrp-msg p a span.yiv3579788207yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3579788207 .yiv3579788207green {
color:#628c2a;}

#yiv3579788207 .yiv3579788207MsoNormal {
margin:0 0 0 0;}

#yiv3579788207 o {
font-size:0;}

#yiv3579788207 #yiv3579788207photos div {
float:left;width:72px;}

#yiv3579788207 #yiv3579788207photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv3579788207 #yiv3579788207photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv3579788207 #yiv3579788207reco-category {
font-size:77%;}

#yiv3579788207 #yiv3579788207reco-desc {
font-size:77%;}

#yiv3579788207 .yiv3579788207replbq {
margin:4px;}

#yiv3579788207 #yiv3579788207ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg select,
#yiv3579788207 input, #yiv3579788207 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg pre, #yiv3579788207
code {
font:115% monospace;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg * {
line-height:1.22em;}

#yiv3579788207 #yiv3579788207ygrp-mlmsg #yiv3579788207logo {
padding-bottom:10px;}


#yiv3579788207 #yiv3579788207ygrp-msg p a {
font-family:Verdana;}

#yiv3579788207 #yiv3579788207ygrp-msg
p#yiv3579788207attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3579788207 #yiv3579788207ygrp-reco
#yiv3579788207reco-head {
color:#ff7900;font-weight:700;}

#yiv3579788207 #yiv3579788207ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
li a {
font-size:130%;text-decoration:none;}

#yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3579788207 #yiv3579788207ygrp-text {
font-family:Georgia;}

#yiv3579788207 #yiv3579788207ygrp-text p {
margin:0 0 1em 0;}

#yiv3579788207 #yiv3579788207ygrp-text tt {
font-size:120%;}

#yiv3579788207 #yiv3579788207ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3579788207

Tue Jan 5, 2016 1:06 am (PST) . Posted by:

"sumbodho"

Terimakasih banyak, akan saya coba. :-) :-)

On 1/5/2016 2:02 PM, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] wrote:
>
>
> --------------------------------------------
> Pada Sel, 5/1/16, sumbodho tososan@rocketmail.com [belajar-excel]
> <belajar-excel@yahoogroups.com> menulis:
>
> Judul: Re: [belajar-excel] Insert foto otomatis dari folder [1 Attachment]
> Kepada: belajar-excel@yahoogroups.com
> Tanggal: Selasa, 5 Januari, 2016, 12:34 PM
>
>
>
> Dear Sumbodho,
>
> Pada sPath = ThisWorkbook.Path &"\" di ganti folder rujukan dimana
> tempatnya foto2 tersebut, misal seperti yang anda sebutkan foto2
> tersebut ada di folder: d:\foto peserta,
>
> maka:
>
> sPath = ThisWorkbook.Path &"\" di ganti jadi :
> sPath = "d:\foto peserta" &"\"
>
> terus:
>
> sFile = Range("c4").Value & ".jpg" adalah nama file (foto name)
> orangnya(peserta), tapi perlu di ingat fotonya yang format "JPG".
> kalo formatnya lain (bukan JPG) missal BMP
>
> maka:
>
> sFile = Range("c4").Value & ".jpg" digant jadi:
> sFile = Range("c4").Value & ".BMP"
>
> Semoga bisa membantu
>
> TerimaKasih.
>
>
>
>
>
>
>
>
> Terimakasih tanggapannya Bang HK,
>
> saya pernah cari2 dan ketemu postingan dengan code2 spt
> ini
>
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Dim sFile As String, sPath As String
>
> If Target.Count = 1 Then
>
> If InStr(Target.Address &
> "|", "$C$3|") <> 0 Then
>
> ActiveSheet.Calculate
>
>
>
> 'ganti rujukan path seperti
> contoh
>
>
> 'drive:\folder\subfolder\
>
> 'contoh :
> E:\myData\mySubData\
>
> sPath = ThisWorkbook.Path &
> "\"
>
> sFile =
> Range("c4").Value & ".jpg"
>
> If LenB(Dir$(sPath & sFile))
> <> 0 Then
>
> imgPeserta.Picture =
> LoadPicture(sPath & sFile)
>
> Else
>
> imgPeserta.Picture =
> LoadPicture(vbNullString)
>
> End If
>
> End If
>
> End If
>
> End Sub
>
>
>
> tapi terus terang saya masih bingung menerapkannnya,
> berikut ini
> saya lampirkan file excel yang sy dapat dengan code di
> atas.
>
>
>
> Realnya kala saya menempatkan foto2 dalam folder
> d:\foto peserta,
> bagaimana mengimplementasikan dalam file dibawah ini.
>
>
>
>
> Terimakasih
>
> Sumbodho
>
>
>
>
>
>
>
> On
> 1/4/2016 10:06 PM, Hendrik Karnadi
> hendrikkarnadi@yahoo.com
> [belajar-excel] wrote:
>
>
>
>
>
> Hai Sumbodho,
> Coba cari di arsip milis.
> Seingat saya Mr. Kid dan mbak Siti pernah
> menjawab
> pertanyaan serupa.
>
>
>
> Salam,
> HK
>
>
>
>
> Sent from
> Samsung Mobile
>
>
>
>
>
> -------- Original message --------
> From: "Sumbodho tososan@rocketmail.com
> [belajar-excel]"
>
> Date:04/01/2016 5:14 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
>
> Subject: [belajar-excel] Insert foto
> otomatis dari
> folder
>
>
>
>
>
> Selamat siang BeExceller.
>
>
>
> Saya mau menanyakan cara insert otomatis di
> excel dari
> foto yg ada di folder. Misal setiap di cell
> a2 diganti
> nama orng/barang maka di cell b6 gambar
> berubah sesuai
> a2.
>
>
>
> Terima kasih tanggapannya.
>
> Sumbodho
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> #yiv3579788207 #yiv3579788207 --
> #yiv3579788207ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp #yiv3579788207hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp #yiv3579788207ads {
> margin-bottom:10px;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad {
> padding:0 0;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad p {
> margin:0;}
>
> #yiv3579788207 #yiv3579788207ygrp-mkp .yiv3579788207ad a {
> color:#0000ff;text-decoration:none;}
> #yiv3579788207 #yiv3579788207ygrp-sponsor
> #yiv3579788207ygrp-lc {
> font-family:Arial;}
>
> #yiv3579788207 #yiv3579788207ygrp-sponsor
> #yiv3579788207ygrp-lc #yiv3579788207hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv3579788207 #yiv3579788207ygrp-sponsor
> #yiv3579788207ygrp-lc .yiv3579788207ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv3579788207 #yiv3579788207actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv3579788207 #yiv3579788207activity {
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv3579788207 #yiv3579788207activity span {
> font-weight:700;}
>
> #yiv3579788207 #yiv3579788207activity span:first-child {
> text-transform:uppercase;}
>
> #yiv3579788207 #yiv3579788207activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv3579788207 #yiv3579788207activity span span {
> color:#ff7900;}
>
> #yiv3579788207 #yiv3579788207activity span
> .yiv3579788207underline {
> text-decoration:underline;}
>
> #yiv3579788207 .yiv3579788207attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv3579788207 .yiv3579788207attach div a {
> text-decoration:none;}
>
> #yiv3579788207 .yiv3579788207attach img {
> border:none;padding-right:5px;}
>
> #yiv3579788207 .yiv3579788207attach label {
> display:block;margin-bottom:5px;}
>
> #yiv3579788207 .yiv3579788207attach label a {
> text-decoration:none;}
>
> #yiv3579788207 blockquote {
> margin:0 0 0 4px;}
>
> #yiv3579788207 .yiv3579788207bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv3579788207 .yiv3579788207bold a {
> text-decoration:none;}
>
> #yiv3579788207 dd.yiv3579788207last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv3579788207 dd.yiv3579788207last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv3579788207 dd.yiv3579788207last p
> span.yiv3579788207yshortcuts {
> margin-right:0;}
>
> #yiv3579788207 div.yiv3579788207attach-table div div a {
> text-decoration:none;}
>
> #yiv3579788207 div.yiv3579788207attach-table {
> width:400px;}
>
> #yiv3579788207 div.yiv3579788207file-title a, #yiv3579788207
> div.yiv3579788207file-title a:active, #yiv3579788207
> div.yiv3579788207file-title a:hover, #yiv3579788207
> div.yiv3579788207file-title a:visited {
> text-decoration:none;}
>
> #yiv3579788207 div.yiv3579788207photo-title a,
> #yiv3579788207 div.yiv3579788207photo-title a:active,
> #yiv3579788207 div.yiv3579788207photo-title a:hover,
> #yiv3579788207 div.yiv3579788207photo-title a:visited {
> text-decoration:none;}
>
> #yiv3579788207 div#yiv3579788207ygrp-mlmsg
> #yiv3579788207ygrp-msg p a span.yiv3579788207yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv3579788207 .yiv3579788207green {
> color:#628c2a;}
>
> #yiv3579788207 .yiv3579788207MsoNormal {
> margin:0 0 0 0;}
>
> #yiv3579788207 o {
> font-size:0;}
>
> #yiv3579788207 #yiv3579788207photos div {
> float:left;width:72px;}
>
> #yiv3579788207 #yiv3579788207photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv3579788207 #yiv3579788207photos div label {
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv3579788207 #yiv3579788207reco-category {
> font-size:77%;}
>
> #yiv3579788207 #yiv3579788207reco-desc {
> font-size:77%;}
>
> #yiv3579788207 .yiv3579788207replbq {
> margin:4px;}
>
> #yiv3579788207 #yiv3579788207ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg select,
> #yiv3579788207 input, #yiv3579788207 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg pre, #yiv3579788207
> code {
> font:115% monospace;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv3579788207 #yiv3579788207ygrp-mlmsg #yiv3579788207logo {
> padding-bottom:10px;}
>
>
> #yiv3579788207 #yiv3579788207ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv3579788207 #yiv3579788207ygrp-msg
> p#yiv3579788207attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv3579788207 #yiv3579788207ygrp-reco
> #yiv3579788207reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv3579788207 #yiv3579788207ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv3579788207 #yiv3579788207ygrp-sponsor #yiv3579788207ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv3579788207 #yiv3579788207ygrp-text {
> font-family:Georgia;}
>
> #yiv3579788207 #yiv3579788207ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv3579788207 #yiv3579788207ygrp-text tt {
> font-size:120%;}
>
> #yiv3579788207 #yiv3579788207ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv3579788207
>
>

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar