Excel in IE browser

[#1]

Hi ,

The below macro working fine in Desktop app but when i used in IE browser plugin then the below macro not working.

Please let me know what might be the problem.

Sub ExportImageInfo

Set Chart = ActiveDocument.GetSheetObject("CH03")

Set P = Chart.GetProperties

Chart.SendToExcel

End Sub

Thanks in advance.

[#2 · Accepted solution]

Hi,

I found the solution for this and i'm sharing this

Here is the solution.

Sub Export

Set excelFile = CreateObject("Excel.Application")

Set WorkBook = excelFile.WorkBooks.Add   

Set Sheet = WorkBook.WorkSheets(1)

Set tableToExport = ActiveDocument.GetSheetObject("CH03")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

Sheet.Paste

     excelFile.Visible = true

End Sub

Regards

....................