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

Not creating text file when run using publisher.

montubhardwaj — Mon, 26 Jan 2026 18:19:17 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

Not creating text file when run using publisher.

SunilChauhan — Mon, 25 Jul 2011 12:37:31 GMT

I believe u need to added urself as distributed user or authenticated user using publisher.

thanks

Sunil Chauhan

Not creating text file when run using publisher.

danielrozental — Mon, 25 Jul 2011 13:13:42 GMT

Publisher doesn't run macros.

What you can do is trigger a reload through publisher. You should look around the forum as I believe this topic has been discussed several times before.

Not creating text file when run using publisher.

SunilChauhan — Mon, 25 Jul 2011 13:18:14 GMT

i believe it should run.because i have a application in 9.0.

and has a macro.after reload its working properly.

If i not understand correctly then please make clear.

thanks

Sunil

Not creating text file when run using publisher.

danielrozental — Mon, 25 Jul 2011 13:22:00 GMT

I think it was clear enough but if you need further explanation.

Macro's will not work when a document is reloaded through qlikview publisher and triggered "on post reload". That trigger will only work when being run in qlikview developer "qv.exe".

Not creating text file when run using publisher.

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

Hi Sunil, thanks for looking into this. The problem is that trigger is being fired on post reload but its not creating the text file But If I reload the qvw manually, it works all fine.

Hi Daniel,

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. Any workaround for this ?

Not creating text file when run using publisher.

montubhardwaj — Tue, 26 Jul 2011 05:35:40 GMT

I also tried to export the field directly using triggers(without macro) on post reload as below but that also did not work.

Document Properties=> Triggers => on post reload => add actions => Exoprt

but this did not work.