Adding row when exporting table to text file with macro

Tue, 18 Mar 2014 11:31:55 GMT

Hi!

I'm trying to write the data from a table to a txt-file on the server.

This works fine with the code below:

Sub test

set tb = ActiveDocument.GetSheetObject("TB01")

tb.ServerSideExportEx "H:\QlikView\Writeback_Excel\UserLogons.txt" , ";" , 1

end sub

It gives me the following text file:

Date;USID

2014-03-17;Daniel

What I would like to do is add another row with data that is not existing i the table.

I thought I could do something like the example below but the script wont run:

Sub test

set tb = ActiveDocument.GetSheetObject("TB01")

tb = tb & "2014-03-18;Sandra"

tb.ServerSideExportEx "H:\QlikView\Writeback_Excel\UserLogons.txt" , ";" , 1

end sub

Any help would be much appreciated!

//Daniel

topic Adding row when exporting table to text file with macro in QlikView