topic Vb macro that would write external excel data then reload the Qvw in QlikView https://community.qlik.com/t5/QlikView/Vb-macro-that-would-write-external-excel-data-then-reload-the/m-p/913361#M316884 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P>I need a VB macro that would updated the excel file then reload the QVW.</P><P></P><P>User will updated the list of quantity then he/she will click the button Update Excel file and Reload</P><P></P><P>The macro will update the Quantity list and also the Total Sales to the excel file then reload the QVW</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/93866_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>Please use my attached files.</P><P></P><P></P><P></P><P>Best Regards,</P></BODY></HTML> Fri, 24 Jul 2015 08:08:30 GMT rbalatbat 2015-07-24T08:08:30Z Vb macro that would write external excel data then reload the Qvw https://community.qlik.com/t5/QlikView/Vb-macro-that-would-write-external-excel-data-then-reload-the/m-p/913361#M316884 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P>I need a VB macro that would updated the excel file then reload the QVW.</P><P></P><P>User will updated the list of quantity then he/she will click the button Update Excel file and Reload</P><P></P><P>The macro will update the Quantity list and also the Total Sales to the excel file then reload the QVW</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/93866_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>Please use my attached files.</P><P></P><P></P><P></P><P>Best Regards,</P></BODY></HTML> Fri, 24 Jul 2015 08:08:30 GMT https://community.qlik.com/t5/QlikView/Vb-macro-that-would-write-external-excel-data-then-reload-the/m-p/913361#M316884 rbalatbat 2015-07-24T08:08:30Z Re: Vb macro that would write external excel data then reload the Qvw https://community.qlik.com/t5/QlikView/Vb-macro-that-would-write-external-excel-data-then-reload-the/m-p/913362#M316885 <HTML><HEAD></HEAD><BODY><P>Hi Rafael,</P><P></P><P>sorry, I cannot help you in the implementation, I've never done it, but for that you need an EDX task that can trigger a reload - there are already some discussions on the issue of EDX reloading here in the Community. Just have a look.</P></BODY></HTML> Fri, 24 Jul 2015 08:10:40 GMT https://community.qlik.com/t5/QlikView/Vb-macro-that-would-write-external-excel-data-then-reload-the/m-p/913362#M316885 datanibbler 2015-07-24T08:10:40Z