Excel in IE browser

Thu, 12 Apr 2012 16:45:29 GMT

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.

Re: Excel in IE browser

Fri, 13 Apr 2012 13:32:10 GMT

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

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