I am trying to do 2 things. The first is to fill a list with directory names within a main directory. Then I want to get word document names within those directories, again in a list.
The first part I am trying seems to only produce documents, no directory names.
Dim sPath As String
Dim sFile As String
sPath = "C:"
sFile = Dir(sPath, vbDirectory)
Me.List2.RowSourceType = "Value List"
Do While sFile <> ""
sFile = Dir