ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Extracting a single file from a zip archive which has multiple files (https://www.excelbanter.com/excel-programming/368821-extracting-single-file-zip-archive-has-multiple-files.html)

[email protected]

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.



All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com