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,
>
>
>
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
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
3 matches
Mail list logo