sudah pak ,dir sub dirnya folder tempat file tersebut kan?nama filenya harus
dengan extensinya gak? misal contoh.csv ditulis di H1nya contoh.csv juga?
Best Regards, Fajar Fatahillah
On Friday, August 26, 2016 4:53 PM, "hendrikkarnadi
[email protected] [belajar-excel]" <[email protected]> wrote:
Hai Fajar,Dir/Sub Dir nya di sel G1 dan nama2 file di sel H1 dstnya sdh
ditulis dengan benar?
Salam,HK
Sent from Samsung Mobile.
-------- Original message --------From: "Fajar Fatahillah
[email protected] [belajar-excel]" Date:08/26/2016 16:29 (GMT+07:00)
To: [email protected] Subject: Re: [belajar-excel] Looping Vba
berdasarkan list tertentu
sudah saya coba,tapi filenya kok gak kebuka ya,hanya muncul message box
Pesan Selesai Ok
Best Regards, Fajar Fatahillah
On Friday, August 26, 2016 3:25 PM, "hendrik karnadi
[email protected] [belajar-excel]" <[email protected]> wrote:
Hai Fajar,Coba buat/copas Macro (Open File) berikut ini,Option Explicit
Sub BukaFile()
Dim Path As String Dim nm_file As Range Dim nm As Range Path =
Range("G1").Value & "\" 'sel G1 berisi (ditulis) Dir dan Sub Dir tempat dimana
file2 berada, mis D:\Coba Set nm_file = Range("H1", Range("H1").End(xlDown))
'Sel H1 dst. berisi nama2 file yang akan dibuka
For Each nm In nm_file On Error GoTo Pesan Workbooks.Open
Filename:=Path & nm Next nmPesan: MsgBox "SELESAI", vbCritical, "P E S A
N"End Sub
Salam,HK
From: "Fajar Fatahillah [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Friday, 26 August 2016, 11:42
Subject: [belajar-excel] Looping Vba berdasarkan list tertentu [1 Attachment]
Dear Para Master Excel,saya ingin membuat aktivitas excel yang rutin
dikerjakan dan berdasarkan list terttentu yang berubah ubah,beberapa aktivitas
tersebut yaitu open file sesuai list di excel td, copy paste , dan save file as
sesuai list juga.
terlampir contoh excelnya
Mohon bantuannya ya
Best Regards, Fajar Fatahillah
#yiv4366944055 #yiv4366944055 -- #yiv4366944055ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4366944055
#yiv4366944055ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4366944055
#yiv4366944055ygrp-mkp #yiv4366944055hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4366944055 #yiv4366944055ygrp-mkp #yiv4366944055ads
{margin-bottom:10px;}#yiv4366944055 #yiv4366944055ygrp-mkp .yiv4366944055ad
{padding:0 0;}#yiv4366944055 #yiv4366944055ygrp-mkp .yiv4366944055ad p
{margin:0;}#yiv4366944055 #yiv4366944055ygrp-mkp .yiv4366944055ad a
{color:#0000ff;text-decoration:none;}#yiv4366944055 #yiv4366944055ygrp-sponsor
#yiv4366944055ygrp-lc {font-family:Arial;}#yiv4366944055
#yiv4366944055ygrp-sponsor #yiv4366944055ygrp-lc #yiv4366944055hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4366944055
#yiv4366944055ygrp-sponsor #yiv4366944055ygrp-lc .yiv4366944055ad
{margin-bottom:10px;padding:0 0;}#yiv4366944055 #yiv4366944055actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4366944055
#yiv4366944055activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4366944055
#yiv4366944055activity span {font-weight:700;}#yiv4366944055
#yiv4366944055activity span:first-child
{text-transform:uppercase;}#yiv4366944055 #yiv4366944055activity span a
{color:#5085b6;text-decoration:none;}#yiv4366944055 #yiv4366944055activity span
span {color:#ff7900;}#yiv4366944055 #yiv4366944055activity span
.yiv4366944055underline {text-decoration:underline;}#yiv4366944055
.yiv4366944055attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4366944055 .yiv4366944055attach div a
{text-decoration:none;}#yiv4366944055 .yiv4366944055attach img
{border:none;padding-right:5px;}#yiv4366944055 .yiv4366944055attach label
{display:block;margin-bottom:5px;}#yiv4366944055 .yiv4366944055attach label a
{text-decoration:none;}#yiv4366944055 blockquote {margin:0 0 0
4px;}#yiv4366944055 .yiv4366944055bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4366944055
.yiv4366944055bold a {text-decoration:none;}#yiv4366944055 dd.yiv4366944055last
p a {font-family:Verdana;font-weight:700;}#yiv4366944055 dd.yiv4366944055last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4366944055
dd.yiv4366944055last p span.yiv4366944055yshortcuts
{margin-right:0;}#yiv4366944055 div.yiv4366944055attach-table div div a
{text-decoration:none;}#yiv4366944055 div.yiv4366944055attach-table
{width:400px;}#yiv4366944055 div.yiv4366944055file-title a, #yiv4366944055
div.yiv4366944055file-title a:active, #yiv4366944055
div.yiv4366944055file-title a:hover, #yiv4366944055 div.yiv4366944055file-title
a:visited {text-decoration:none;}#yiv4366944055 div.yiv4366944055photo-title a,
#yiv4366944055 div.yiv4366944055photo-title a:active, #yiv4366944055
div.yiv4366944055photo-title a:hover, #yiv4366944055
div.yiv4366944055photo-title a:visited {text-decoration:none;}#yiv4366944055
div#yiv4366944055ygrp-mlmsg #yiv4366944055ygrp-msg p a
span.yiv4366944055yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4366944055
.yiv4366944055green {color:#628c2a;}#yiv4366944055 .yiv4366944055MsoNormal
{margin:0 0 0 0;}#yiv4366944055 o {font-size:0;}#yiv4366944055
#yiv4366944055photos div {float:left;width:72px;}#yiv4366944055
#yiv4366944055photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4366944055
#yiv4366944055photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4366944055
#yiv4366944055reco-category {font-size:77%;}#yiv4366944055
#yiv4366944055reco-desc {font-size:77%;}#yiv4366944055 .yiv4366944055replbq
{margin:4px;}#yiv4366944055 #yiv4366944055ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4366944055 #yiv4366944055ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4366944055
#yiv4366944055ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4366944055
#yiv4366944055ygrp-mlmsg select, #yiv4366944055 input, #yiv4366944055 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4366944055
#yiv4366944055ygrp-mlmsg pre, #yiv4366944055 code {font:115%
monospace;}#yiv4366944055 #yiv4366944055ygrp-mlmsg *
{line-height:1.22em;}#yiv4366944055 #yiv4366944055ygrp-mlmsg #yiv4366944055logo
{padding-bottom:10px;}#yiv4366944055 #yiv4366944055ygrp-msg p a
{font-family:Verdana;}#yiv4366944055 #yiv4366944055ygrp-msg
p#yiv4366944055attach-count span {color:#1E66AE;font-weight:700;}#yiv4366944055
#yiv4366944055ygrp-reco #yiv4366944055reco-head
{color:#ff7900;font-weight:700;}#yiv4366944055 #yiv4366944055ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4366944055 #yiv4366944055ygrp-sponsor
#yiv4366944055ov li a {font-size:130%;text-decoration:none;}#yiv4366944055
#yiv4366944055ygrp-sponsor #yiv4366944055ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4366944055
#yiv4366944055ygrp-sponsor #yiv4366944055ov ul {margin:0;padding:0 0 0
8px;}#yiv4366944055 #yiv4366944055ygrp-text
{font-family:Georgia;}#yiv4366944055 #yiv4366944055ygrp-text p {margin:0 0 1em
0;}#yiv4366944055 #yiv4366944055ygrp-text tt {font-size:120%;}#yiv4366944055
#yiv4366944055ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4366944055
