Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

Type Mismatch on copyObjectsToExcelSheet

i used this script to copy table to excel

Sub export_situation()

set val=ActiveDocument.Fields("souad").GetPossibleValues

for i=0 to val.Count-1

ActiveDocument.Fields("souad").Select (val.Item(i).Text)

set objagenceClient = ActiveDocument.GetSheetObject("tablesouad")

sheetname=val.Item(i).Text

Dim aryExport(6,3)

aryExport(i,0) = "tablesouad"

aryExport(i,1) = val.Item(i).Text

aryExport(i,2) = "A1"

aryExport(i,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

next

end Sub

but i have this error

Capture.PNG

1 Solution

Accepted Solutions

Re: Type Mismatch on copyObjectsToExcelSheet

Your code is incomplete. Take here a look into the origin posting: QlikTip #32: Exporting multiple QV objects to a single Excel document.

- Marcus

1 Reply

Re: Type Mismatch on copyObjectsToExcelSheet

Your code is incomplete. Take here a look into the origin posting: QlikTip #32: Exporting multiple QV objects to a single Excel document.

- Marcus

Community Browser