topic Problem creating text file when run using publisher. in QlikView

Problem creating text file when run using publisher.

montubhardwaj — Tue, 26 Jul 2011 05:57:44 GMT

Hi All,

I have an application in which I have created a list box from a variable. Now, Using Macro, I am exporting this list box to a text file. I am triggering this Macro(which contains the code to export list box to text file) on Post reload. This is working all fine when I am running my application manually and creating a text file as desired. But when I am running the same application using publisher, the text file is not getting created. Can someone please let me know where it is going wrong ?

Regards,

Sharma

Problem creating text file when run using publisher.

montubhardwaj — Tue, 26 Jul 2011 05:59:38 GMT

Below is the macro which I have written for exporting List Box to text file.

sub test

set lb = ActiveDocument.GetSheetObject("LB01")

lb.Export "C:\Documents and Settings\USER\Desktop\test.txt" , ";"

end sub

This macro is fired on Post Reload. But when the file is reloaded using publisher, its is not working. This works all fine if qvw is reloaded manually.

Any workaround for this ?