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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

1 Solution

Accepted Solutions
Not applicable
Author

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



View solution in original post

3 Replies
Not applicable
Author

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



Not applicable
Author

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

richard_chilvers
Specialist
Specialist

Solved my problem too