topic How do I create a VBscript to export data from 2 sheetobject in one .CSV in QlikView

How do I create a VBscript to export data from 2 sheetobject in one .CSV

Tue, 13 Apr 2010 15:12:56 GMT

Hy people,
I have the following Macro:

sub test

set Obj = ActiveDocument.GetSheetObject("304")

obj.Export "c:\Test.CSV",","

end sub

Indeed, I would export with pleasure the object 303 still in the csv file 304 and 303 in test.csv

What i can do?

Wed, 14 Apr 2010 17:19:49 GMT

In order to append the second object try this:

set Obj = ActiveDocument.GetSheetObject("303")

obj.Export "c:\Test.CSV",","

set Obj = ActiveDocument.GetSheetObject("304")

obj.Export "c:\Test.CSV" , "," , , TRUE

watch the 4th parameter.

Alex

Thu, 15 Apr 2010 09:40:10 GMT

Thank you to you,
has clapped perfectly. Thank you to you!

richard_chilvers — Wed, 20 Feb 2013 14:42:40 GMT

Solved my problem too