Zipping a group of files using generic zipping code

[KenCriss]

The following code works great for zipping all files in a folder. But I have a need to feed a list of files into the macro instead of zipping the entire folder. Is there a way to revise the code to do this? Not sure it matters, but all the files will have an extension of .DAT. Thanks for any advice.

Sub CreateZipFile(folderToZipPath As Variant, zippedFileFullName As Variant)

Dim ShellApp As Object

'Create an empty zip file
Open zippedFileFullName For Output As #1
Print #1, Chr$(80) & Chr$(75) & Chr$(5) & Chr$(6) & String(18, 0)
Close #1

'Copy the files & folders into the zip file
Set ShellApp = CreateObject("Shell.Application")
ShellApp.Namespace(zippedFileFullName).CopyHere ShellApp.Namespace(folderToZipPath).items

'Zipping the files may take a while, create loop to pause the macro until zipping has finished.
On Error Resume Next
Do Until ShellApp.Namespace(zippedFileFullName).items.Count = ShellApp.Namespace(folderToZipPath).items.Count
    Application.Wait (Now + TimeValue("0:00:01"))
    Exit Do
Loop
On Error GoTo 0

End Sub

Sub MakeZip()
Call CreateZipFile("U:\WS_Users\KWC\Temp\TEST", "U:\WS_Users\KWC\Temp\MyCompanyZip.zip")
MsgBox "Done!"
End Sub

 

[John_w]

See if you can adapt this code for a similar request:

Zip series of files with same prefix in the same folder

Hello. I need help coding to zip files with same prefix in name. Every day, I receive 200 files like these in 1 folder: 1111111111_1321435435_HD_SL.pdf 1111111111_1321435436_HD_SL.pdf 1111111111_1321435437_HD_SL.pdf 2222222222_2542875575_HD_SL.pdf 2222222222_2542875576_HD_SL.pdf I manually...

www.mrexcel.com

Your main proc should probably be something like (copy the variable declarations) :

Sub MakeZip()
    sourceFolder = "U:\WS_Users\KWC\Temp\TEST\"
    file = Dir(sourceFolder & "*.dat")
    While file <> vbNullString
        Zip_File sourceFolder & file, "U:\WS_Users\KWC\Temp\MyCompanyZip.zip"
        file = Dir
    Wend
    MsgBox "Done!"
End Sub

 

[KenCriss]

I saw that post and thought about that....the problem is I only need to zip some of the .DAT files in a folder, not all of them. I'll play around with it. Thanks for the reply.

 

[sdohertyccb]

what is the function" Zip_File" in John W 's reply?

 

[John_w]

what is the function" Zip_File" in John W 's reply?

It's in the thread I linked to.