Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export Text Object as Image in Excel Cell

Hi,

do you know if is possible to export a text object(contains an Image) as image in excel  cell?

i do this code but doesn't works:

set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True 'Visible set as true

set XLDoc = XLApp.Workbooks.Add

set XLSheet2 = XLDoc.Worksheets.Add

XLSheet2.Range("A1:AD1").ColumnWidth = 8.43

XLSheet2.Range("A1:A1").ROWHEIGHT = 27

XLSheet2.Range("A1:C4").MergeCells=true

set logodx = ActiveDocument.GetSheetObject("TX21")

logodx.CopyBitmapToClipboard 

XLSheet2.Paste  XLSheet2.Range("A1:C4") 'Paste data into cell

XLsheet2.Cells.Borders.LineStyle = 1

and have a message box:

"Data on the clipboard is not the same size and shape as the selcted area.do you want to paste the data aniway?"

i Click yes but nothing appears in the cell.

many thanks and best regatrds

0 Replies