View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Audie G. Bencosme R. Audie G. Bencosme R. is offline
external usenet poster
 
Posts: 4
Default How to open a zip file and extract its contents in a macro?

Hi
I need to save space in my hard disk so i have to zip some files, but i need
them for consulting values and make some reports, i need to run a macro that
opens the zip file, extract the workbook copy some values from it and then
close it without making changes, and close the zip file.
The zip file and the workbook have the same name.
This operation is done by hand 5 times everyday so you'll understand my
need.
Please any help is needed