CODEWITHSUNDEEP
vbscript
nwpulele
nwpulele

Reputation: 219

How to traverse subfolders in a zip file and unzip files with specific extension?

Basically I'm trying to unzip some specific files in a zip file (there are lots of junk subfolders in it).

The thing is only the last subfolder contains files I want. Other subfolders won't contain any files except another subfolder.

enter image description here

Here is the code I'm currently using:

ZipFile="C:\Test.zip" 
ExtractTo="C:\" 
Set fso = CreateObject("Scripting.FileSystemObject") 
If NOT fso.FolderExists(ExtractTo) Then  
    fso.CreateFolder(ExtractTo) 
End If 
set objShell = CreateObject("Shell.Application") 
set FilesInZip= objShell.NameSpace(ZipFile).items
print "There are " & FilesInZip.Count & " files" 
'Output will be 1 because there is only one subfolder there.
objShell.NameSpace(ExtractTo).CopyHere(FilesInZip) 
Set fso = Nothing 
Set objShell = Nothing

Is there anyway I can traverse subfolder and only unzip files with a specific extension?

Upvotes: 3

Views: 2139

Answers (1)

Ansgar Wiechers
Ansgar Wiechers

Reputation: 200273

You can do that with a recursive procedure that calls itself for folder items and extracts file items if they have a specific extension:

Set fso = CreateObject("Scripting.FileSystemObject")
Set app = CreateObject("Shell.Application")

Sub ExtractByExtension(fldr, ext, dst)
  For Each f In fldr.Items
    If f.Type = "File folder" Then
      ExtractByExtension f.GetFolder, ext, dst
    ElseIf LCase(fso.GetExtensionName(f.Name)) = LCase(ext) Then
      app.NameSpace(dst).CopyHere f.Path
    End If
  Next
End Sub

ExtractByExtension app.NameSpace("C:\path\to\your.zip"), "txt", "C:\output"

Upvotes: 2

Related Questions