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!
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!