Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding row when exporting table to text file with macro

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

0 Replies