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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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?

Labels (1)
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