Dlm file saya sih ga pakai file extension. Coba kirim dummy filenya. Salam, HK
Sent from Samsung Mobile. <div>-------- Original message --------</div><div>From: "Fajar Fatahillah [email protected] [belajar-excel]" <[email protected]> </div><div>Date:08/26/2016 16:58 (GMT+07:00) </div><div>To: [email protected] </div><div>Subject: Re: [belajar-excel] Looping Vba berdasarkan list tertentu </div><div> </div>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 nm Pesan: 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
