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