Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ComboBox Question
- Thread starter LinuxGuy
- Start date
Dim fso As FileSystemObject, myfile As File
myCombo = myForm.Combobox1
Set fso = New FileSystemObject
myCombo.clear
For Each myfile In fso.GetFolder("c:\"
.Files
If right(myfile.Name,3) = "xls" then
myCombo.additem(myFile.name)
Next
HTH Rgds
~Geoff~
myCombo = myForm.Combobox1
Set fso = New FileSystemObject
myCombo.clear
For Each myfile In fso.GetFolder("c:\"
.FilesIf right(myfile.Name,3) = "xls" then
myCombo.additem(myFile.name)
Next
HTH Rgds
~Geoff~
- Status
Similar threads
- Locked
- Question