Re: [belajar-excel] Mencari Alamat File (Path), NEXT ke kolom B6

2019-07-12 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
Kalau pakai VBA dan PowerQuery (lebih cepat) di file xlfilefolderlist_vba_n_pq.xlsm Kalau pakai VBA dengan fitur FSO di file re-PATH.xlsm Regards, Kid On Thu, Jul 11, 2019 at 5:10 PM y.ron...@yahoo.com [belajar-excel] < belajar-excel@yahoogroups.com> wrote: > > > Dear Master Vba, > > >

Re: [belajar-excel] Mencari Alamat File (Path), NEXT ke kolom B6

2019-07-11 Terurut Topik hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
Dear Roni,Coba code ini,Sub Subfoldersandfolders()    Dim FSO As Object    Dim FSOFolder As Object    Dim Objfile As Object    Dim subfd As Object    Dim x As String    Dim i As Integer 'baris data    Dim n As Integer 'no urut        Application.FileDialog(msoFileDialogFolderPicker).Show    x

[belajar-excel] Mencari Alamat File (Path), NEXT ke kolom B6

2019-07-11 Terurut Topik y.ron...@yahoo.com [belajar-excel]
Dear Master Vba, Terlampir File untuk mencari Alamat File (Path). Yang Saya butuhkan, yaitu saat NEXT ke kolom berikutnya (B6) tanpa menimpa kolom sebelumnya. Mohon dibantu koreksi scriptnya berikut: Sub Subfoldersandfolders() Dim FSO As Object Dim FSOFolder As Object Dim Objfile