Hi, I am trying to unzip all .zip files which are in a folder. The files will be unzipped to the same folder and the .zip file should be deleted after unzipping. Below is my code. When I try to run, I get an error "Run time error '91': Object variable or With block variable not set" at the red line below.
I googled a lot to resolve this but in vain. I am running Excel 2010 32 bit on Windows 7 64 bit. I think this has got to do with setting Tools -> References but I dont know which one it is. Your help is much appreciated.
Bookmarks