topic Re: Export to excel in QlikView https://community.qlik.com/t5/QlikView/Export-to-excel/m-p/402803#M149862 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Can anybody help me out from this issue, I tried the following code that is alos not helpless</P><P></P><P>if (pasteMode = "image") then</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;With objExcelApp.Selection</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Interior.Color= RGB(25,25,112)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End With&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end if&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Could you please suggest any solution for this.............</P></BODY></HTML> Mon, 04 Mar 2013 12:57:43 GMT 2013-03-04T12:57:43Z Export to excel https://community.qlik.com/t5/QlikView/Export-to-excel/m-p/402802#M149861 <HTML><HEAD></HEAD><BODY><P>Hello friends,</P><P></P><P>As I have a macro from QV to export excel in the platform of (Windows XP and Mo-office 2010) its working fine but the same code in Windows 7, the image color is filled with a colour and not able to see the image for instance if you see in the attached test.xlsx file "Summary of Data" background is filled with Black colour.</P><P></P><P>Is there any workaround for this...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 04 Mar 2013 10:11:37 GMT https://community.qlik.com/t5/QlikView/Export-to-excel/m-p/402802#M149861 2013-03-04T10:11:37Z Re: Export to excel https://community.qlik.com/t5/QlikView/Export-to-excel/m-p/402803#M149862 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Can anybody help me out from this issue, I tried the following code that is alos not helpless</P><P></P><P>if (pasteMode = "image") then</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;With objExcelApp.Selection</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Interior.Color= RGB(25,25,112)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End With&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end if&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Could you please suggest any solution for this.............</P></BODY></HTML> Mon, 04 Mar 2013 12:57:43 GMT https://community.qlik.com/t5/QlikView/Export-to-excel/m-p/402803#M149862 2013-03-04T12:57:43Z