Problem creating text file when run using publisher.
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 ?
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.
