create password protected file with peazip

#CREATE PASSWORD PROTECTED FILE WITH PEAZIP ZIP FILE#
#CREATE PASSWORD PROTECTED FILE WITH PEAZIP SOFTWARE#

Change the paths to be the folder you wish to zip and the name you want the zip folder to be called. To call the procedure above the following code can be used within another procedure.

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

#CREATE PASSWORD PROTECTED FILE WITH PEAZIP ZIP FILE#

'Copy the files & folders into the zip file Set ShellApp = CreateObject('Shell.Application') Sub CreateZipFile(folderToZipPath As Variant, zippedFileFullName As Variant)ĭim ShellApp As Object 'Create an empty zip file Open zippedFileFullName For Output As #1 Wait for all the zip files to stop compressing.Copy the files from the folder into the zip file.Declare a Variant variable to hold the file paths, this will ensure the code runs smoothly. Do not declare a String variable to hold the file paths, this will not work with the Shell.Application. UPDATE: As discussed in the comments section below. VBA code to copy, move, delete and manage files.VBA code to create, delete and manage folders.Check out the following code snippets to cover these areas: These code snippets do not create, delete or check for the existence of the files or folders which it uses. The code below was created for that purpose. Whilst working with Zip files, I wanted to make a reusable procedure which I could call when ever required. The code snippets below are based on a section from Excel 2016 Power Programming with VBA by Michael Alexander/Dick Kusleika and from Ron de Bruin’s site. Putting all the attachments into a single zip file can help get around this issue, as the files are compressed to be smaller. For example, Google currently allows a maximum file size of 25MB to be sent.

#CREATE PASSWORD PROTECTED FILE WITH PEAZIP SOFTWARE#

As software becomes more complex, file sizes increase, however there is often a limit to the file size an e-mail provider will allow. Zip files are now a common method of compressing files and folders for sharing. Recently, I have been working on a project which requires the zipping and unzipping files and folders.

Create password protected file with peazip