Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Developers
I want to exports all objects(images) from a sheet to excel. I have the vb script to send the data into excel,but i want to send images to excel,i tried many vb scripts but i am unable to achieve the requirement below is the script i am using to export images to excel i am getting error (Blue Line) Can someone Help me please?
ErrorMessage: Type mismatch: 'copyObjectsToExcelSheet'
vPathVariant3 = "C:\Users\dimsum2\Desktop\qvd\Data.xlsx"
Dim aryExport(0,3)
aryExport(0,0) = "CH824"
aryExport(0,1) = "Per Month"
aryExport(0,2) = "A1"
aryExport(0,3) = "image"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)
objExcelWorkbook.SaveAs "C:\Users\dimsum2\Desktop\qvd\data.xlsx"
objExcelWorkbook.Application.Quit
Thanks
Anil Danda
Anil, the code to export several objects is that I´ve pasted above