auto reload on desktop version

[Anonymous]

Dear all,

I tried the autoreload (by a windows task) and it works. The problem is that the system opens a new istance of Qlikview for each reload.

I need to reload any 5 minutes, so after 10 minutes I've two active instances of the document.

What can I do to solve it ?

Thanks in advance

[luciancotea]

Create a RunAndClose.vbs file and run it:

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("C:\QlikView\MyApp.qvw","","")
Set ActiveDocument = MyDoc
ActiveDocument.Reload
MyDoc.GetApplication.Quit
Set MyDoc = Nothing
Set MyApp = Nothing

[Anonymous]

Hi Lucian,

thanks for your answer.

Just one thing: how can I create a vbs file ? I'm sorry, but I never used them.

Thanks in advance

[luciancotea]

Create a text (.txt) file in Notepad, then change the extension to .vbs

[Anonymous]

Thanks!!

If I understood (but I'm not sure) the script, it opens my document and close it.

What I'm trying to do is that , after the first time, when I launch again the reload process, I should kill the previous instance if is activem in order to have only one open document.

Is it possible to do ?

[luciancotea]

Then why don't you reload from macro every 10 min without closing the document?

Use Now () function to calculate if more than 10 minutes passed from last reload.

[Anonymous]

Because I don't know how to use macro...

[luciancotea]

Press CTRL+M to show the Macro window. Paste this:

Sub ReloadDoc
   ActiveDocument.Reload
   ActiveDocument.Save
End sub

This macro will reload and save your doc every time you call it.