Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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