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

How do I create a VBscript to export data from a sheetobject to .CSV file

Wed, 09 Dec 2009 06:21:46 GMT

Hello All,

I've not done much vbscripting, so I'm looking for some code snippets for a macro which exports data from a sheet object to a .CSV file. There is the export option by right clicking on the object but we would like to be able to do this via a Button; and if possible let this process run in the background thus allowing the user to still use the tool while exporting very large data set. Any suggestions would be appreciated.

How do I create a VBscript to export data from a sheetobject to .CSV file

Wed, 09 Dec 2009 06:59:29 GMT

Okay, I've manage to create a button to export to .CSV, I had a the wrong Objectid in the getsheet object call. My second question, is it possible to run the download as separate process or background process using the vbscripting language? The files that we are exporting are quite large and time consuming. I'm thinking the data is locked so that no changes occurr to the data while the export is in progress so it may not be possible. Any thoughts on this will be appreciated.

Nadir

How do I create a VBscript to export data from a sheetobject to .CSV file

Anonymous — Fri, 11 Dec 2009 11:03:07 GMT

Nadir,

I don't have an answer to your questions but would appreciate seeing your code for exporting to a text file from a button.

Regards,

John.

How do I create a VBscript to export data from a sheetobject to .CSV file

Sat, 12 Dec 2009 00:05:20 GMT

John,

Here is the code I used to export to a .CSV file :

Sub SR37
'Download Sheet ojbect data to CSV
set sObject = ActiveDocument.GetSheetObject("CH24")
sObject.Export "C:\TEST.CSV",","
End Sub

I use a button object to trigger this subroutine.

Nadir

How do I create a VBscript to export data from a sheetobject to .CSV file

Anonymous — Mon, 14 Dec 2009 04:29:58 GMT

Nadir,

thanks for this.

John.