topic refresh doc through macro after calling batch file in QlikView

refresh doc through macro after calling batch file

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: refresh doc through macro after calling batch file

arthur_dom — Thu, 03 Jan 2013 12:01:21 GMT

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'

Re: refresh doc through macro after calling batch file

Thu, 03 Jan 2013 12:08:57 GMT

The content of the batch file is :

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

Re: refresh doc through macro after calling batch file

Thu, 24 Jan 2013 07:29:28 GMT

Hi All,

This issue is fixed!.

Please see this thread!

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

Regards,

Anju