unzip

Hello guys, I have a code where it will unzip specific file based on file path provided. But I want to unzip all zip files present in the folder. Public Sub Unzip() Dim localZipFile As Variant, destFolder As Variant Dim Sh As Object localZipFile = "C:\folder\path\test.zip"...

Hi All I need to unzip a file by a keyword of a file since the file name contents some variable numbers and dates which are varied with the date. Therefore I tried to create a code to unzip a file by its keyword. I tried to use a function with a sub but it does not respond me. How do I fix...

Hi I'm trying to loop through all the files in a directory, including subdirectories and copy anything that has the word 'spec' in it to another location. It work fine until I come across a zip file, which has subdirectories in it. Does anyone know how I loop through files in a subdirectory of...

Hi All, Could anyone please help me with a code to unzip the folder using VBA. Since I have around 130 files which needs unzipping on a monthly to do reconciliation which takes more than 5 hours for me to Unzip and paste the data into a excel sheet. Thanks

So I have spent WAY too much time trying to get to this answer. Below is what I need to get at...and yes, I have been to RondeBruin's site and it hasn't helped much from my limited knowledge. I have Excel 2010, WinZip16.0 (winzip64.exe), Internet Explorer 11 Download .zip file from site (I...

Can someone please let me know what is wrong with the code below? I am trying to unzip a file using winzip64 and I also want to overwrite any existing files that are extracted. Currently the code runs without errors but it also doesn't extract the file to the location. Sub...

I have a folder (C:\Zipped) that contains many zipped files (.gz) I have installed 7-Zip Can someone please tell me what is the command in DOS to unzip all the files in C:\Zipped Better still, is there a single command that moves files and unzips (or the other way round)? Thanks

Hi, I found this script on the internet and am using it to unzip a file, but I get a confirmation button to press if the file is already there. I either need to delete the zip file first, if there is one, or dont have the confirmation screen, how do I go about that? Sub TestRun() 'Change...

My question is in 2 parts: 1. Look up folders and all it's subfolders and unzip files in the same name (in the same path) as the source files using a VBA. 2. Normally when we unzip a file, the individual files get unzipped in 2nd level. For example, when we unzip file named Data.rar (or...

Hi all, Just taken advantage of: VLOOKUP Awesome Quick - by Bill 'MrExcel' Jelen http://www.mrexcel.com/store/index.php?l=product_detail&p=229 Downloaded it and when I come to unzip it, on a Mac, it goes round in a loop VLAQ_ePub.zip double click VLAQ_ePub.zip.cpgz double click VLAQ_ePub...