Dear Odhy,
Sepertinya apa yang anda inginkan sulit di wujudkan, masalahnya bagaimana
membuka file di drive C yang notabene drive pribadi bisa di buka oleh computer
lain.Artiya kalo mau di buka bersama, harus di tempatkan di drive dimana semua
computer bisa membukanya.Jangan pernah memaksakan jika memang sulit untuk di
lakukan, Excel di buat untuk mempermudah bukan menyulitkan..
TerimaKasih.
Pada Kamis, 2 Maret 2017 14:27, "Odhy [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear para master,Maksudku begini, database foto tetap di computer saya
namun tetap bisa terlihat di computer lain. mungkin dengan cara menambahkan
script agar padaa saat lookup foto sekaligus copy foto di file tersebut, jadi
pada saat dibuka di computer lain tidak lookup / ngelink ke database foto.
demikian atas bantuannya saya ucapkan banyak terima kasih.
Terima Kasih atas pencerahannya, Odhy.
On Thursday, March 2, 2017 12:00 PM, "hendrik karnadi
[email protected] [belajar-excel]" <[email protected]> wrote:
Dan extension filenya juga...
Sent from Yahoo Mail on Android
Dear Odhy,
Pastikan Path yang tertulis dalam script sesuai dengan path computer lain
(C:\Katalog Material\03. dBase Foto Marketing\" & Target.Value & ".jpg")
Terimakasih.
Pada Kamis, 2 Maret 2017 11:34, "Odhy [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Master,untuk lookup foto ke folder sudah running, namun kendalanya
saat saya mau kirim file tersebut atau buka di computer lain fotonya tidak
kelihatan.nah bagaimana caranya / scriptnya biar foto tersebut biasa dibuka di
computer lain.
// script untuk lookup foto yang saya gunakan yaitu :
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [B:B]) Is Nothing Then Exit Sub
If Target.Row Mod 100 = 0 Then Exit Sub
On Error GoTo son
ActiveSheet.Pictures.Insert(Path & "C:\Katalog Material\03. dBase Foto
Marketing\" & Target.Value & ".jpg").Select
Selection.Top = Target.Offset(0, 4).Top
Selection.Left = Target.Offset(0, 4).Left
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Height = Target.Offset(0, 4).Height
Selection.ShapeRange.Width = Target.Offset(0, 4).Width
Target.Offset(1, 0).Select
son:
End Sub
atas bantunnay saya ucapkan banyak-banyak terima kasih.Salam,Odhy.
#yiv9143422142 #yiv9143422142 -- #yiv9143422142ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9143422142
#yiv9143422142ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9143422142
#yiv9143422142ygrp-mkp #yiv9143422142hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9143422142 #yiv9143422142ygrp-mkp #yiv9143422142ads
{margin-bottom:10px;}#yiv9143422142 #yiv9143422142ygrp-mkp .yiv9143422142ad
{padding:0 0;}#yiv9143422142 #yiv9143422142ygrp-mkp .yiv9143422142ad p
{margin:0;}#yiv9143422142 #yiv9143422142ygrp-mkp .yiv9143422142ad a
{color:#0000ff;text-decoration:none;}#yiv9143422142 #yiv9143422142ygrp-sponsor
#yiv9143422142ygrp-lc {font-family:Arial;}#yiv9143422142
#yiv9143422142ygrp-sponsor #yiv9143422142ygrp-lc #yiv9143422142hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9143422142
#yiv9143422142ygrp-sponsor #yiv9143422142ygrp-lc .yiv9143422142ad
{margin-bottom:10px;padding:0 0;}#yiv9143422142 #yiv9143422142actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9143422142
#yiv9143422142activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9143422142
#yiv9143422142activity span {font-weight:700;}#yiv9143422142
#yiv9143422142activity span:first-child
{text-transform:uppercase;}#yiv9143422142 #yiv9143422142activity span a
{color:#5085b6;text-decoration:none;}#yiv9143422142 #yiv9143422142activity span
span {color:#ff7900;}#yiv9143422142 #yiv9143422142activity span
.yiv9143422142underline {text-decoration:underline;}#yiv9143422142
.yiv9143422142attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9143422142 .yiv9143422142attach div a
{text-decoration:none;}#yiv9143422142 .yiv9143422142attach img
{border:none;padding-right:5px;}#yiv9143422142 .yiv9143422142attach label
{display:block;margin-bottom:5px;}#yiv9143422142 .yiv9143422142attach label a
{text-decoration:none;}#yiv9143422142 blockquote {margin:0 0 0
4px;}#yiv9143422142 .yiv9143422142bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9143422142
.yiv9143422142bold a {text-decoration:none;}#yiv9143422142 dd.yiv9143422142last
p a {font-family:Verdana;font-weight:700;}#yiv9143422142 dd.yiv9143422142last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9143422142
dd.yiv9143422142last p span.yiv9143422142yshortcuts
{margin-right:0;}#yiv9143422142 div.yiv9143422142attach-table div div a
{text-decoration:none;}#yiv9143422142 div.yiv9143422142attach-table
{width:400px;}#yiv9143422142 div.yiv9143422142file-title a, #yiv9143422142
div.yiv9143422142file-title a:active, #yiv9143422142
div.yiv9143422142file-title a:hover, #yiv9143422142 div.yiv9143422142file-title
a:visited {text-decoration:none;}#yiv9143422142 div.yiv9143422142photo-title a,
#yiv9143422142 div.yiv9143422142photo-title a:active, #yiv9143422142
div.yiv9143422142photo-title a:hover, #yiv9143422142
div.yiv9143422142photo-title a:visited {text-decoration:none;}#yiv9143422142
div#yiv9143422142ygrp-mlmsg #yiv9143422142ygrp-msg p a
span.yiv9143422142yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9143422142
.yiv9143422142green {color:#628c2a;}#yiv9143422142 .yiv9143422142MsoNormal
{margin:0 0 0 0;}#yiv9143422142 o {font-size:0;}#yiv9143422142
#yiv9143422142photos div {float:left;width:72px;}#yiv9143422142
#yiv9143422142photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9143422142
#yiv9143422142photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9143422142
#yiv9143422142reco-category {font-size:77%;}#yiv9143422142
#yiv9143422142reco-desc {font-size:77%;}#yiv9143422142 .yiv9143422142replbq
{margin:4px;}#yiv9143422142 #yiv9143422142ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9143422142 #yiv9143422142ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9143422142
#yiv9143422142ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9143422142
#yiv9143422142ygrp-mlmsg select, #yiv9143422142 input, #yiv9143422142 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9143422142
#yiv9143422142ygrp-mlmsg pre, #yiv9143422142 code {font:115%
monospace;}#yiv9143422142 #yiv9143422142ygrp-mlmsg *
{line-height:1.22em;}#yiv9143422142 #yiv9143422142ygrp-mlmsg #yiv9143422142logo
{padding-bottom:10px;}#yiv9143422142 #yiv9143422142ygrp-msg p a
{font-family:Verdana;}#yiv9143422142 #yiv9143422142ygrp-msg
p#yiv9143422142attach-count span {color:#1E66AE;font-weight:700;}#yiv9143422142
#yiv9143422142ygrp-reco #yiv9143422142reco-head
{color:#ff7900;font-weight:700;}#yiv9143422142 #yiv9143422142ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9143422142 #yiv9143422142ygrp-sponsor
#yiv9143422142ov li a {font-size:130%;text-decoration:none;}#yiv9143422142
#yiv9143422142ygrp-sponsor #yiv9143422142ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9143422142
#yiv9143422142ygrp-sponsor #yiv9143422142ov ul {margin:0;padding:0 0 0
8px;}#yiv9143422142 #yiv9143422142ygrp-text
{font-family:Georgia;}#yiv9143422142 #yiv9143422142ygrp-text p {margin:0 0 1em
0;}#yiv9143422142 #yiv9143422142ygrp-text tt {font-size:120%;}#yiv9143422142
#yiv9143422142ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9143422142
