topic Export Text Box Background Image to Excel in QlikView https://community.qlik.com/t5/QlikView/Export-Text-Box-Background-Image-to-Excel/m-p/577354#M214734 <HTML><HEAD></HEAD><BODY><P>I am trying to create a custom Excel export macro that will create a spreadsheet of multiple data charts as well as a corporate logo.&nbsp; I can easily get the data tables exported into the right spots on the Excel but so far all of my macros have been failing when trying to copy out the text box. I'm pasting a code snip below...</P><P></P><P>'Export Logo</P><P>set MyTable = ActiveDocument.GetSheetObject("RTK_LOGO") </P><P>set XLSheet = XLDoc.Worksheets(1)</P><P>Mytable.CopyBitmapToClipboard true</P><P>XLSheet.Paste XLSheet.Range("A1") </P><P></P><P>I've confirmed the text box I want is properly named as above.</P><P></P><P>Thoughts on how I can make this happen?</P></BODY></HTML> Sun, 30 Mar 2014 03:09:52 GMT 2014-03-30T03:09:52Z Export Text Box Background Image to Excel https://community.qlik.com/t5/QlikView/Export-Text-Box-Background-Image-to-Excel/m-p/577354#M214734 <HTML><HEAD></HEAD><BODY><P>I am trying to create a custom Excel export macro that will create a spreadsheet of multiple data charts as well as a corporate logo.&nbsp; I can easily get the data tables exported into the right spots on the Excel but so far all of my macros have been failing when trying to copy out the text box. I'm pasting a code snip below...</P><P></P><P>'Export Logo</P><P>set MyTable = ActiveDocument.GetSheetObject("RTK_LOGO") </P><P>set XLSheet = XLDoc.Worksheets(1)</P><P>Mytable.CopyBitmapToClipboard true</P><P>XLSheet.Paste XLSheet.Range("A1") </P><P></P><P>I've confirmed the text box I want is properly named as above.</P><P></P><P>Thoughts on how I can make this happen?</P></BODY></HTML> Sun, 30 Mar 2014 03:09:52 GMT https://community.qlik.com/t5/QlikView/Export-Text-Box-Background-Image-to-Excel/m-p/577354#M214734 2014-03-30T03:09:52Z