I have a folder that contains .csv files that are exported using another system. I want my users to click the combo box and have the list of files within that directory be items to select. What's the best method? Any literature on this? Thanks!
I have a folder that contains .csv files that are exported using another system. I want my users to click the combo box and have the list of files within that directory be items to select. What's the best method? Any literature on this? Thanks!
Code:Dim FSO As Object, fld As Object, Fil As Object Dim SubFolderName As String Dim i As Integer Set FSO = CreateObject("Scripting.FileSystemObject") SubFolderName = "\\Fdlxrdw1\mstr_dmapp_prd\" Set fld = FSO.GetFolder(SubFolderName) For Each Fil In fld.Files i = i + 1 If Right(Fil, 4) = ".csv" Then Me.cboSelFile.AddItem Fil.Name End If Next Fil