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

macro to Export an Object as an "Object" from QV to Excel File

In may Dahbord , I create a multiple list of selection an filters .

Manually , I can export Object from QV to my Excel File.

I want to export an Object automatically with Macro.

I create a macro that export "data" (values) and "image" from QVW to Excel , but Not an Object.


sub exportToExcel_Variant3

Dim aryExport(1,3)

aryExport(0,0) = "CH893"

aryExport(0,1) = "Feuil1"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

aryExport(1,0) = "CH893"

aryExport(1,1) = "Feuil1"

aryExport(1,2) = "E1"

aryExport(1,3) = "image"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

Is that possible to export Object to Excel files with macro ??

1 Reply
Not applicable
Author

Probably , there is not a solution to export Object from Qlikview to Excel By macro .

I want to have interaction between objects exported by macro in my Excel Sheet .

Any Idea Please ??