topic Re: Where can I get Macro Script to format and excel export in QlikView https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462897#M696011 <HTML><HEAD></HEAD><BODY><P>The best way is google and you find sites like this:</P><P></P><P><A class="loading active_link" href="http://www.functionx.com/vbaexcel/cells/Lesson2.htm" title="http://www.functionx.com/vbaexcel/cells/Lesson2.htm">http://www.functionx.com/vbaexcel/cells/Lesson2.htm</A></P><P></P><P>- Marcus</P></BODY></HTML> Wed, 17 Apr 2013 13:31:50 GMT marcus_sommer 2013-04-17T13:31:50Z Where can I get Macro Script to format and excel export https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462896#M696010 <HTML><HEAD></HEAD><BODY><P>I have been creating a macro script to export to Excel however am battling to format the excel file in the Macro script.</P><P>SOme of the things I want to be able to do are:</P><P>Centre Align</P><P>Create borders</P><P>fill cells with colour</P><P>Insert a logo</P><P>etc</P></BODY></HTML> Wed, 17 Apr 2013 11:48:02 GMT https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462896#M696010 2013-04-17T11:48:02Z Re: Where can I get Macro Script to format and excel export https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462897#M696011 <HTML><HEAD></HEAD><BODY><P>The best way is google and you find sites like this:</P><P></P><P><A class="loading active_link" href="http://www.functionx.com/vbaexcel/cells/Lesson2.htm" title="http://www.functionx.com/vbaexcel/cells/Lesson2.htm">http://www.functionx.com/vbaexcel/cells/Lesson2.htm</A></P><P></P><P>- Marcus</P></BODY></HTML> Wed, 17 Apr 2013 13:31:50 GMT https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462897#M696011 marcus_sommer 2013-04-17T13:31:50Z Re: Where can I get Macro Script to format and excel export https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462898#M696012 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus, that I will surely give a try. </P><P>Was googling myself comotose yesterday and couldn't find things like the link you sent me!</P></BODY></HTML> Thu, 18 Apr 2013 04:49:35 GMT https://community.qlik.com/t5/QlikView/Where-can-I-get-Macro-Script-to-format-and-excel-export/m-p/462898#M696012 2013-04-18T04:49:35Z