refresh doc through macro after calling batch file

[#1]

Hi All,

I am calling a batch file to reload the document from macro.

After it is reloaded successfully,

I want a dialogue box to be displayed saying "Reload Finished" and also execute  ActiveDocument.SetClearState

This is what I did:

Sub External

    Set WSHShell = CreateObject("Wscript.Shell")

    exitcode=WSHShell.Run("D:\testserver.bat",0,TRUE)---line x //this reloads the doc

        if(exitcode=0) then

     WSHShell.Popup "Reload Finished"

        ActiveDocument.SetClearState   

end if

End Sub

But, it is timing out, I think at line x.

If I give only

WSHShell.Run("D:\testserver.bat")

ActiveDocument.SetClearState----this doesn't get executed

Hence I am not able to see the reloaded data .I have to refresh the doc manually.

How can I solve this?

-Anju

[arthur_dom]

What is in the Batch file?

If you add the Path on the system variables  you can run a batch file with the line

'qv <file location     >  /r'

[#3]

The content of the batch file is :

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\QlikViewMount\RN60-ConsolidatedCostofProgrammingReport.qvw"

[#4 · Accepted solution]

Hi All,

This issue is fixed!.

Please see this thread!

http://community.qlik.com/message/293671#293671

Regards,

Anju