Hi,
i want to Populate Listindex (with 2 columns) with files and its Path/location in directory
I can mange to get all files name i Listbox' but not the second column, I don,t know how to get it.
for example:
(column 1) School in London (column 2) R:\Education\School\Region\School in north.pdf
a.s.o
i want to Populate Listindex (with 2 columns) with files and its Path/location in directory
I can mange to get all files name i Listbox' but not the second column, I don,t know how to get it.
for example:
(column 1) School in London (column 2) R:\Education\School\Region\School in north.pdf
a.s.o
VBA Code:
Private Sub CommandButton10_Click()
'
Dim MyFolder As String
Dim MyFile As String
Dim j As Integer
MyFolder = "R:\Education\School\Region"
MyFile = Dir(MyFolder & "\*.*")
Do While MyFile <> ""
Page6ListBox2.AddItem MyFile
MyFile = Dir
Loop
End Sub