Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

refresh doc through macro after calling batch file

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

This issue is fixed!.

Please see this thread!

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

Regards,

Anju

View solution in original post

3 Replies
arthur_dom
Creator III
Creator III

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'

Not applicable
Author

The content of the batch file is :

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

Not applicable
Author

Hi All,

This issue is fixed!.

Please see this thread!

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

Regards,

Anju