working with zip files

[zzjasonzz]

Every week i get a zip file with 10-15 .csv files that i need to extract then apply formatting a resave.

Is there anyway to work directly with the zip file without extracting all files.

I can do it if i extract all the files into a folder then run the vba on the folder to format and resave was just wondering if its possible to do without extracting.

Any ideas? thanks!