SLiDE said:
Specifically, I have files zipped that I would like to list in one column in Excel; such as...
--somehow I need to be able to "create a list of files" from a directory on my computer that I can specify.
Well, you can take care of the folder specification issue yourself by creating a folder path and then going into WinZip and extracting the zipped files to that folder path. Let's say you name the folder path on your C drive as Your \ Folder \ Path \ . The following macro will look at that path and list all the filenames in it into column A, with a bolded header in cell A1 to remind you what that path is:
Sub Test1()
Application.ScreenUpdating = False
Columns(1).Clear
Dim i As Long, F As String
F = " C: \ Your \ File \ Path \ "
With Range("A1")
.Value = "Files in " & F & ":"
.Font.Bold = True
End With
With Application.FileSearch
.NewSearch
.LookIn = F
.SearchSubFolders = False
.filename = "*.*"
If .Execute > 0 Then
For i = 1 To .FoundFiles.Count
Cells(i + 1, 1).Value = .FoundFiles(i)
Next i
End If
End With
Columns(1).AutoFit
Application.ScreenUpdating = True
End Sub
Note, remove the extra spaces in this line:
F = "C: \ Your \ File \ Path \ "
Even though I disabled HTML on this post, the web plays tricks with those characters and really there should be no spaces in that Path string.
