mac create zip file command line of a folder

' Copyright : The following is release as Attribution-ShareAlike 4.0 International ' Author : Daniel Pineault, CARDA Consultants Inc. With this information, we need only create a wrapper procedure to build the PowerShell command and pass it to my PS_Execute sub. With a single line, you’re done! The basic syntax is: Compress-Archive -LiteralPath SourcePath -DestinationPath DestinationPath

To Zip/Compress a File, or an entire folder, you can use the Compress-Archive PowerShell cmdlet. So combining the PS_Execute() sub from VBA – Run PowerShell Command with either of these commands and we have the ability to create zip files or extract the content of a zip file with 1 line of code.īelow are 2 procedures I created to illustrated how this can be done.įile Zipping/Compression with PowerShell through VBA What I found out was the fact that PowerShell can perform either of these action using a single line of code! No APIs, dlls or convoluted modules. So I thought I’d take a second look at a common need zipping/unzipping and see if PowerShell could possibly simplify a developers life. PowerShell basically can do everything on a PC (Networking, Hardware, ActiveDirectory, Events, …), once you know which cmdlet to use! Since then, I’ve furthered my education in PowerShell and have had my eyes opened to its true power and simplicity (once you understand the basics). PowerShell to the Rescue!?Ī short while back, for fun, I explored invoking PowerShell commands through VBA and created a series of procedures and shared them in my article entitles VBA – Run PowerShell Command.

Compression and decompression methods for VBAīut, I thought, that perhaps we could explore a newer, and perhaps easier, approach today.

VBA code to Zip and Unzip files and folders.

I know, I know, you’ve already seen code that can zip and unzip files.

Mac create zip file command line of a folder