Hello
I search for code to print out all of files are showed in listbox .
the files are existed in folders & subfolders
for instance :
"C:\Users\TU\Desktop\BTR\ NN_125678888.PDF"
"C:\Users\TU\Desktop\BTR\ MONTH\SLKH_MM-12222F.PDF"
"C:\Users\TU\Desktop\BTR\ MONTH\DATA\SLNMUMM-1234.PDF"
the files names are in third column(3) in listbox and will be the same files names as in directory like this
NN_125678888
SLKH_MM-12222F
SLNMUMM-1234
so I want to print out all of files are showed in listbox on userform after matching the third column(3) in listbox with files are existed in directory through folders & subfolders
and if the listbox is empty ,then when run the code should show message "the listbox is empty, there is no data to print out" and doesn't print in this case.
thanks
I search for code to print out all of files are showed in listbox .
the files are existed in folders & subfolders
for instance :
"C:\Users\TU\Desktop\BTR\ NN_125678888.PDF"
"C:\Users\TU\Desktop\BTR\ MONTH\SLKH_MM-12222F.PDF"
"C:\Users\TU\Desktop\BTR\ MONTH\DATA\SLNMUMM-1234.PDF"
the files names are in third column(3) in listbox and will be the same files names as in directory like this
NN_125678888
SLKH_MM-12222F
SLNMUMM-1234
so I want to print out all of files are showed in listbox on userform after matching the third column(3) in listbox with files are existed in directory through folders & subfolders
and if the listbox is empty ,then when run the code should show message "the listbox is empty, there is no data to print out" and doesn't print in this case.
thanks
