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

    Export Text Object as Image in Excel Cell


      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


      set logodx = ActiveDocument.GetSheetObject("TX21")


      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