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

 

[Fluff]

Duplicate to: Zipping a group of files using generic zipping code

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.