TerimakasihSemuanya
Maaf jika dengan code
Buat sheet bernama INPUTdi cells A1 ditulis lokasi filenya, misal :
D:\Documen1\Data ActiveWorkbook.FollowHyperlink
Sheets("INPUT").range("a1").text
tetap harus ditentukan drive nya (drive D), bagaimana jika file / datanya saya
letakkan di drive mana saja (semua drive bisa yang terpenting nama file yang
dimakasud) misalkan folder Database1 jika dipanggil atau dibuka akan langsung
terbuka. walaupun disimpan di drive misalkan C atau D ataupun tempat lain.
Mohon pencerahannya
Terimakasih
Pada Senin, 19 Agustus 2019 14.17.20 WIB, hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>
menulis:
Hai Hairul,
"bagaimana bila saya tempatkan file di drive misal C atau F tanpa merubah macro
setiap harus pindah file/folder"
Meminjam code Mr. Kid,....
Kalau tidak mau merubah Macronya ya harus ubah acuan pada Sheetnya.
Mis.
Range("A1") ditulis "D:\Document\" (tanpa spasi)
Range("A2") ditulis "Data.extnya" (tanpa spasi)
Codenya menjadi :
ActiveWorkbook.FollowHyperlink NamaSheetnya.Range("A1") & Range("A2").Text
Jika File "Data.extnya" (tanpa spasi) dipindah...mis ke Directory F:\ maka
Range("A1") ditulis "F:\" (tanpa spasi)
Codenya tetap:
ActiveWorkbook.FollowHyperlink NamaSheetnya.Range("A1") & Range("A2").Text
Jadi prinsipnya harus ngelink ke lokasi yang tepat.
Salam,HK
----- Pesan yang Diteruskan -----
Dari: 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Terkirim: Senin, 19 Agustus 2019 01.07.43 WIB
Judul: Re: [belajar-excel] Buka folder dengan macro excel
Wa'alaikumussalam wr wb,
Buat sheet bernama INPUT
di cells A1 ditulis lokasi filenya, misal : D:\Documen1\Data
ActiveWorkbook.FollowHyperlink Sheets("INPUT").range("a1").text
Wa'alaikumussalam wr wb,
Kid
On Thu, Aug 8, 2019 at 9:47 PM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
>
>
>
>
>
>
> Salam Para Master
>
> Kalau saya hendak membuka file dengan membuat code macro ;
>
> Sub DOCUMENT1()
> 'Data1 = "D:\Documen1\Data"
> ActiveWorkbook.FollowHyperlink Data1
> End Sub
>
> code tersebut hanya bisa di buka pada folder yang ada di drive D saja, tapi
> bagaimana bila saya tempatkan file di drive misal C atau F tanpa merubah
> macro setiap harus pindah file/folder..
>
> Terimakasih
> Assalamualaikum
> Hairul Alam
>
>
>
>
>
>
#yiv6649739775 #yiv6649739775 -- #yiv6649739775ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6649739775
#yiv6649739775ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6649739775
#yiv6649739775ygrp-mkp #yiv6649739775hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6649739775 #yiv6649739775ygrp-mkp #yiv6649739775ads
{margin-bottom:10px;}#yiv6649739775 #yiv6649739775ygrp-mkp .yiv6649739775ad
{padding:0 0;}#yiv6649739775 #yiv6649739775ygrp-mkp .yiv6649739775ad p
{margin:0;}#yiv6649739775 #yiv6649739775ygrp-mkp .yiv6649739775ad a
{color:#0000ff;text-decoration:none;}#yiv6649739775 #yiv6649739775ygrp-sponsor
#yiv6649739775ygrp-lc {font-family:Arial;}#yiv6649739775
#yiv6649739775ygrp-sponsor #yiv6649739775ygrp-lc #yiv6649739775hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6649739775
#yiv6649739775ygrp-sponsor #yiv6649739775ygrp-lc .yiv6649739775ad
{margin-bottom:10px;padding:0 0;}#yiv6649739775 #yiv6649739775actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6649739775
#yiv6649739775activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6649739775
#yiv6649739775activity span {font-weight:700;}#yiv6649739775
#yiv6649739775activity span:first-child
{text-transform:uppercase;}#yiv6649739775 #yiv6649739775activity span a
{color:#5085b6;text-decoration:none;}#yiv6649739775 #yiv6649739775activity span
span {color:#ff7900;}#yiv6649739775 #yiv6649739775activity span
.yiv6649739775underline {text-decoration:underline;}#yiv6649739775
.yiv6649739775attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6649739775 .yiv6649739775attach div a
{text-decoration:none;}#yiv6649739775 .yiv6649739775attach img
{border:none;padding-right:5px;}#yiv6649739775 .yiv6649739775attach label
{display:block;margin-bottom:5px;}#yiv6649739775 .yiv6649739775attach label a
{text-decoration:none;}#yiv6649739775 blockquote {margin:0 0 0
4px;}#yiv6649739775 .yiv6649739775bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6649739775
.yiv6649739775bold a {text-decoration:none;}#yiv6649739775 dd.yiv6649739775last
p a {font-family:Verdana;font-weight:700;}#yiv6649739775 dd.yiv6649739775last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6649739775
dd.yiv6649739775last p span.yiv6649739775yshortcuts
{margin-right:0;}#yiv6649739775 div.yiv6649739775attach-table div div a
{text-decoration:none;}#yiv6649739775 div.yiv6649739775attach-table
{width:400px;}#yiv6649739775 div.yiv6649739775file-title a, #yiv6649739775
div.yiv6649739775file-title a:active, #yiv6649739775
div.yiv6649739775file-title a:hover, #yiv6649739775 div.yiv6649739775file-title
a:visited {text-decoration:none;}#yiv6649739775 div.yiv6649739775photo-title a,
#yiv6649739775 div.yiv6649739775photo-title a:active, #yiv6649739775
div.yiv6649739775photo-title a:hover, #yiv6649739775
div.yiv6649739775photo-title a:visited {text-decoration:none;}#yiv6649739775
div#yiv6649739775ygrp-mlmsg #yiv6649739775ygrp-msg p a
span.yiv6649739775yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6649739775
.yiv6649739775green {color:#628c2a;}#yiv6649739775 .yiv6649739775MsoNormal
{margin:0 0 0 0;}#yiv6649739775 o {font-size:0;}#yiv6649739775
#yiv6649739775photos div {float:left;width:72px;}#yiv6649739775
#yiv6649739775photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6649739775
#yiv6649739775photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6649739775
#yiv6649739775reco-category {font-size:77%;}#yiv6649739775
#yiv6649739775reco-desc {font-size:77%;}#yiv6649739775 .yiv6649739775replbq
{margin:4px;}#yiv6649739775 #yiv6649739775ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6649739775 #yiv6649739775ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6649739775
#yiv6649739775ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6649739775
#yiv6649739775ygrp-mlmsg select, #yiv6649739775 input, #yiv6649739775 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6649739775
#yiv6649739775ygrp-mlmsg pre, #yiv6649739775 code {font:115%
monospace;}#yiv6649739775 #yiv6649739775ygrp-mlmsg *
{line-height:1.22em;}#yiv6649739775 #yiv6649739775ygrp-mlmsg #yiv6649739775logo
{padding-bottom:10px;}#yiv6649739775 #yiv6649739775ygrp-msg p a
{font-family:Verdana;}#yiv6649739775 #yiv6649739775ygrp-msg
p#yiv6649739775attach-count span {color:#1E66AE;font-weight:700;}#yiv6649739775
#yiv6649739775ygrp-reco #yiv6649739775reco-head
{color:#ff7900;font-weight:700;}#yiv6649739775 #yiv6649739775ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6649739775 #yiv6649739775ygrp-sponsor
#yiv6649739775ov li a {font-size:130%;text-decoration:none;}#yiv6649739775
#yiv6649739775ygrp-sponsor #yiv6649739775ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6649739775
#yiv6649739775ygrp-sponsor #yiv6649739775ov ul {margin:0;padding:0 0 0
8px;}#yiv6649739775 #yiv6649739775ygrp-text
{font-family:Georgia;}#yiv6649739775 #yiv6649739775ygrp-text p {margin:0 0 1em
0;}#yiv6649739775 #yiv6649739775ygrp-text tt {font-size:120%;}#yiv6649739775
#yiv6649739775ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6649739775
