0 Replies Latest reply: May 22, 2013 4:41 AM by Brian Rzeznik RSS

    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