topic Text Alignment For Multibox while exporting through macro in QlikView https://community.qlik.com/t5/QlikView/Text-Alignment-For-Multibox-while-exporting-through-macro/m-p/593797#M220055 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have using Macro to Export the sheet objects to Excel, But while i Export the Multibox to excel&nbsp; the text Alignment is becoming '<STRONG>Center</STRONG>' though i have given the Alignment as '<STRONG>Left</STRONG>' in presentation. I am using the following Code for export.</P><P>-----------------------------------------------------------------------------------------</P><P><STRONG>set mybox = ActiveDocument.GetSheetObject("MB51")</STRONG></P><P><STRONG>mbp = mybox.GetProperties</STRONG></P><P><STRONG>mbp.TextAdjust = 0</STRONG></P><P><STRONG>mbp.NumAdjust = 0</STRONG></P><P><STRONG>mybox.SetProperties mbp</STRONG></P><P><STRONG>mybox.CopyTableToClipboard(true)</STRONG></P><P><STRONG>curSheet.Range("A" &amp; 15).Select</STRONG></P><P><STRONG>curSheet.Paste&nbsp; </STRONG>&nbsp;&nbsp; </P><P>---------------------------------------------------------------------------------------</P><P>Kindly Help me out with a solution for this.</P><P></P><P>Thanks in Advance...</P></BODY></HTML> Wed, 19 Mar 2014 09:30:31 GMT 2014-03-19T09:30:31Z Text Alignment For Multibox while exporting through macro https://community.qlik.com/t5/QlikView/Text-Alignment-For-Multibox-while-exporting-through-macro/m-p/593797#M220055 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have using Macro to Export the sheet objects to Excel, But while i Export the Multibox to excel&nbsp; the text Alignment is becoming '<STRONG>Center</STRONG>' though i have given the Alignment as '<STRONG>Left</STRONG>' in presentation. I am using the following Code for export.</P><P>-----------------------------------------------------------------------------------------</P><P><STRONG>set mybox = ActiveDocument.GetSheetObject("MB51")</STRONG></P><P><STRONG>mbp = mybox.GetProperties</STRONG></P><P><STRONG>mbp.TextAdjust = 0</STRONG></P><P><STRONG>mbp.NumAdjust = 0</STRONG></P><P><STRONG>mybox.SetProperties mbp</STRONG></P><P><STRONG>mybox.CopyTableToClipboard(true)</STRONG></P><P><STRONG>curSheet.Range("A" &amp; 15).Select</STRONG></P><P><STRONG>curSheet.Paste&nbsp; </STRONG>&nbsp;&nbsp; </P><P>---------------------------------------------------------------------------------------</P><P>Kindly Help me out with a solution for this.</P><P></P><P>Thanks in Advance...</P></BODY></HTML> Wed, 19 Mar 2014 09:30:31 GMT https://community.qlik.com/t5/QlikView/Text-Alignment-For-Multibox-while-exporting-through-macro/m-p/593797#M220055 2014-03-19T09:30:31Z