Populating listbox from network directory

[Guest]

Is it possible to have a listbox on a userform populate with the contents
(names of workbooks) of a network directory? I know it's possible in VB, but
I can't figure out how to do this in VBA.

Thanks, Lee

 

[Jim Rech]

An example of one way to do it:

Private Sub UserForm_Initialize()
Dim FName As String
FName = Dir("c:\files\*.xls")
While FName <> ""
ListBox1.AddItem FName
FName = Dir
Wend
End Sub

--
Jim Rech
Excel MVP
| Is it possible to have a listbox on a userform populate with the contents
| (names of workbooks) of a network directory? I know it's possible in VB,
but
| I can't figure out how to do this in VBA.
|
| Thanks, Lee