View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sumitmehta82@gmail.com is offline
external usenet poster
 
Posts: 1
Default Extracting a single file from a zip archive which has multiple files

Hi,

Hi, Im attempting to unzip a particular file from a zip archive. I
browsed through Ron's website and found the the code for unzipping ALL
files in that archive. But my archive has 50 odd files and I just want
to extract 1 particular file from it.

How can I tweak the following line of code so that it unzips a
particular file only?

oApp.Namespace(FileNameFolder).CopyHere oApp.Namespace(fname).Items

Many thanks in advance,

Cheers
Sumit.