topic Re: CSV Files in QlikView

CSV Files

Thu, 20 Jun 2013 06:28:45 GMT

I need to create CSV file...

but the same way as I did for excel using CREATEOBJECT("EXCEL.APPLICATION")

Set XLApp=CREATEOBJECT("EXCEL.APPLICATION")

So how can I use CreateObject to Create CSV files..

Regards

Avadhoot

Gysbert_Wassenaar — Thu, 20 Jun 2013 06:41:57 GMT

You don't need to create an application object to export to csv. Just use the Export member:

Sub ExportToCSV

set obj= ActiveDocument.GetSheetObject("CH01")

obj .Export "C:\File.csv", ", "

End Sub