topic Re: Macro to zip in QlikView https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215782#M389414 <HTML><HEAD></HEAD><BODY><P>Qlik itself couldn't zip/unzip files. This meant you will further need batches which do the job. Here: <A href="https://community.qlik.com/message/1189016">Re: Macro to move file to another folder</A> you will see two different ways how you could trigger suc a batch - either with a vbs-macro or with an execute statement (which called the batch directly or like in the example over a windows task).</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 09 Jan 2017 13:12:45 GMT marcus_sommer 2017-01-09T13:12:45Z Macro to zip https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215781#M389413 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I have the following VB macro which zips a file and password protects it. It works just fine in excel (as long as you remember to put CHR$(34) around Mypassword, target and source)</P><P></P><P><STRONG>&nbsp;&nbsp;&nbsp; Shell ("C:\Program Files (x86)\WinZip\WINZIP32.EXE -min -a -s" &amp; Mypassword &amp; " " &amp; target &amp; " " &amp; source)</STRONG></P><P></P><P>I can't seem to work out how to convert this into qlikview - can anyone make any suggestions? </P></BODY></HTML> Mon, 09 Jan 2017 12:54:08 GMT https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215781#M389413 Anonymous 2017-01-09T12:54:08Z Re: Macro to zip https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215782#M389414 <HTML><HEAD></HEAD><BODY><P>Qlik itself couldn't zip/unzip files. This meant you will further need batches which do the job. Here: <A href="https://community.qlik.com/message/1189016">Re: Macro to move file to another folder</A> you will see two different ways how you could trigger suc a batch - either with a vbs-macro or with an execute statement (which called the batch directly or like in the example over a windows task).</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 09 Jan 2017 13:12:45 GMT https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215782#M389414 marcus_sommer 2017-01-09T13:12:45Z Re: Macro to zip https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215783#M389415 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus i'll take a look</P></BODY></HTML> Mon, 09 Jan 2017 13:47:20 GMT https://community.qlik.com/t5/QlikView/Macro-to-zip/m-p/1215783#M389415 Anonymous 2017-01-09T13:47:20Z