zip files

Hello All, I hope all of you are doing well. Can you kindly assist me on the below. I am struggling for months to get this code. I am not an expert at coding hence requesting you all to help me out. Below are the requirements the code. 1. The VBA should go through all the folder and...

Hi I'm having trouble importing about 14,000 XML files that are in a compressed zip.file to Microsoft excel. If anyone knows the best way to do this would be great! Cheers, Lauren

I have a Zip file that contains more Zip files (Zipception?). ZipFileParent\ ZipFileChild1 ZipFileChild2 ZipFileChild3 ZipFileChild4 ZipFileChild5 Basically I need to read/edit the comments for the ZipFileParent, as well as the ZipFileChilds. I'm pretty experienced...

Is there a way to access a zip file's contents through VBA? I'm hoping to avoid manually downloading the Fama French factors each month, and instead set up a web query or VBA routine to pull them into Excel. The data is on this web page: Kenneth R. French - Data Library And this is the...

Hi Everyone! I was wondering whether anyone could help me please? I need to automate the download of zip files. I can write a code to download other file types from websites but when it downloads a zip, the file corrupts. Is there something that is different about downloading .zip files...

Hi, I am trying to create a code that opens a particular folder and zip each file that is inside it. Then I want to copy each of these files to another folder. Lets say the first folder is C:\Old Folder And when all the files in this folder are zipped, I want to move it to a folder: J:\new...