topic Re: Macro for table caption back ground color and remove table borders in QlikView https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86520#M14200 <HTML><HEAD></HEAD><BODY><P>Hey no luck for me, can you please provide alternate macro for getting expected out put.</P><P></P><P></P><P>Thanks,</P><P>Ram.</P></BODY></HTML> Tue, 16 Oct 2018 06:24:45 GMT ramachandra_gee 2018-10-16T06:24:45Z Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86512#M14192 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>we have an interesting requirement from the user.</P><P>they want the out put as excel with caption color and removing boders in the chart while exporting as excel.</P><P></P><P>please find the attched it is exporting as aexcel with palin caption and table borders are coming .please take this macro as a reference and do need to full help.</P><P></P><P></P><P><STRONG></STRONG></P><P></P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Tue, 09 Oct 2018 08:39:07 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86512#M14192 ramachandra_gee 2018-10-09T08:39:07Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86513#M14193 <HTML><HEAD></HEAD><BODY><P>see attached</P><P></P><P>hope this helps</P></BODY></HTML> Tue, 09 Oct 2018 09:51:41 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86513#M14193 Frank_Hartmann 2018-10-09T09:51:41Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86514#M14194 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply but it is not matching with my requirement.still i am getting borders and caption color is not coming.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215452_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Thanks,</P><P>Ram.</P></BODY></HTML> Tue, 09 Oct 2018 10:21:03 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86514#M14194 ramachandra_gee 2018-10-09T10:21:03Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86515#M14195 <HTML><HEAD></HEAD><BODY><P>check attached file</P></BODY></HTML> Tue, 09 Oct 2018 10:26:03 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86515#M14195 Frank_Hartmann 2018-10-09T10:26:03Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86516#M14196 <HTML><HEAD></HEAD><BODY><P>no luck ,still i am getting same output</P></BODY></HTML> Tue, 09 Oct 2018 11:07:48 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86516#M14196 ramachandra_gee 2018-10-09T11:07:48Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86517#M14197 <HTML><HEAD></HEAD><BODY><P>strange. this is what i get:</P><P></P><P><IMG alt="Aufnahme_2018_10_09_13_22_14_860.gif" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215459_Aufnahme_2018_10_09_13_22_14_860.gif" style="height: 417px; width: 620px;" /></P></BODY></HTML> Tue, 09 Oct 2018 11:23:33 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86517#M14197 Frank_Hartmann 2018-10-09T11:23:33Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86518#M14198 <HTML><HEAD></HEAD><BODY><P>Hi Frank. I think the problem may be with the default sheet name in different languages. <SPAN style="font-size: 10pt; line-height: 1.5em;">I've added&nbsp; </SPAN></P><P> WorkBook.ActiveSheet.Name = "Sheet1"</P></BODY></HTML> Tue, 09 Oct 2018 13:20:17 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86518#M14198 andrey_krylov 2018-10-09T13:20:17Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86519#M14199 <HTML><HEAD></HEAD><BODY><P>thats what i changed in my second attached app based on his screenshot!</P></BODY></HTML> Tue, 09 Oct 2018 13:25:39 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86519#M14199 Frank_Hartmann 2018-10-09T13:25:39Z Re: Macro for table caption back ground color and remove table borders https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86520#M14200 <HTML><HEAD></HEAD><BODY><P>Hey no luck for me, can you please provide alternate macro for getting expected out put.</P><P></P><P></P><P>Thanks,</P><P>Ram.</P></BODY></HTML> Tue, 16 Oct 2018 06:24:45 GMT https://community.qlik.com/t5/QlikView/Macro-for-table-caption-back-ground-color-and-remove-table/m-p/86520#M14200 ramachandra_gee 2018-10-16T06:24:45Z