Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel in IE browser

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

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

View solution in original post

1 Reply
Not applicable
Author

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

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