Hi
I am trying to list the contents of a folder in a combobox, but can't seem to find any help on this anywhere...
Can anyone help..?
Cheers
Luke
Full Version: List files in a folder...
Hi Luke
Have a look in the VBA help files for FileSystemObject which will do what you want.
Please post back if you have any problems using it
Have a look in the VBA help files for FileSystemObject which will do what you want.
Please post back if you have any problems using it
Hi Alan
Sorry to be a pain, but I get keyword not found when I search for help on that. Would you give me a hand with this..?
Cheers..!
Luke
Sorry to be a pain, but I get keyword not found when I search for help on that. Would you give me a hand with this..?
Cheers..!
Luke
Hi Luke
Some thing like this:
Some thing like this:
CODE
Sub FileListDemo()
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("C:\")
For Each objFile In objFolder.Files
Debug.Print objFile.name
Next objFile
End Sub
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("C:\")
For Each objFile In objFolder.Files
Debug.Print objFile.name
Next objFile
End Sub
Hi
Using Larry's code, you could build a comma seperated string to assign to the RowSource of your combo using a Value List as the row Source Type
Using Larry's code, you could build a comma seperated string to assign to the RowSource of your combo using a Value List as the row Source Type
Excellent, thanks loads guys...
Luke
Luke
Glad we could help
D'oh!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.