Export to CSV using qlikview macro module, trouble with saveAS

Fri, 20 Feb 2015 20:56:54 GMT

Having issue exporting my file to csv using the macro. If i do it on excel it works perfectly, if i copy the code, i get an expected statement error and i am unable to process it, is there any known troubles in this domain ?

Here is what i did via the macro :

- create a worksheet getting the objects of my dashbaord,

- create a second worksheet2 where i create lines for my csv file in a single column and i hardcoded the separator for example i have :

text;text;ContentofMyTableCell1;date;text

text;text;ContentofMyTableCell2;date;text

text;text;ContentofMyTable2Cell1;date;text

text;text;ContentofMyTable2Cell2;date;text

when i want to save i tried the

workbook.saveAs (name) ====> that works but produce me a xls

workbook.saveAs(name,xlCSV) ====> Error cannot call a sub in parenthesis

workbook saveAs filename:= name, fileFormat:=xlCSV =====> error expected statement

any ideas ?

Re: Export to CSV using qlikview macro module, trouble with saveAS

Gysbert_Wassenaar — Sat, 21 Feb 2015 11:28:10 GMT

Did you define the constant xlCSV in your code? If not try using the value 6 instead.

Re: Export to CSV using qlikview macro module, trouble with saveAS

marcus_sommer — Sun, 22 Feb 2015 19:33:51 GMT

CSV as file-format had several limitations - one is it supported only one worksheet and this is probably why your error occured.

- Marcus

topic Export to CSV using qlikview macro module, trouble with saveAS in QlikView

Export to CSV using qlikview macro module, trouble with saveAS

Re: Export to CSV using qlikview macro module, trouble with saveAS

Re: Export to CSV using qlikview macro module, trouble with saveAS