Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's a snippit of code (attached to a userform) that I use to list files
contained in a folder. This code only picks up files contained in the folder selected and not in any sub-folders of that folder. What change(s) do I need to make so that the code identifies files contained in sub-floders also? If OptionButton1 Then EXT = "*.MP3" ElseIf OptionButton2 Then EXT = "*.CDG" ElseIf OptionButton3 Then EXT = "*.ZIP" ElseIf OptionButton4 Then EXT = "*.*" End If With Application.FileDialog(msoFileDialogFolderPicker) .Show ThePath = .SelectedItems(1) & "\" End With fname = Dir(ThePath & EXT) TIA...Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn off "Initializing Folders" every time I open a file. | Excel Discussion (Misc queries) | |||
Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
"Search for files and folders" option doesnot work for 100% | Excel Discussion (Misc queries) |