Not creating text file when run using publisher.

[montubhardwaj]

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

[SunilChauhan]

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

thanks

Sunil Chauhan

[danielrozental]

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.

[SunilChauhan]

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

and has a macro.after reload its working properly.

or

If i not understand correctly then please make clear.

thanks

Sunil

[danielrozental]

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".

[montubhardwaj]

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 ?

[montubhardwaj]

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.