<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
There are 3-15 folders in a big folder. Need VBA or some other way to do this:<br />
If the main folder is C:\Main, then if there are any folders in that directory, zip it please.<br />
So for example – if there are 4 folders in C:\Main, then after this code magic, 4 zipped files are created out of those 4 folders.
</div>
</div>


Hello

There are 3-15 folders in a big folder. Need VBA or some other way to do this:
If the main folder is C:\Main, then if there are any folders in that directory, zip it please.
So for example – if there are 4 folders in C:\Main, then after this code magic, 4 zipped files are created out of those 4 folders.

Zip VBA Shell (Zip multiple folders in a main folder)

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.