How do i get my Qlikview document to automatically reload?

[hopkinsc]

Hi, i have created a Document which uses a spreadsheet for its data, The spreadsheet is updated on a daily basis. At the moment, after i launch the Qlikview doc, i have to click relaunch to update the values from the spreadsheet. Can this be done automatically on launch of the document?

[#2]

hi

create a macro

sub reload

ActiveDocument.Reload

end sub

and set it to run on open document

regards

Peter

[hopkinsc]

Thanks very much Peter, that worked fine. I tried doing that earlier today but i was using the SELECTION command instead of ACTIVEDOCUMENT.

Thanks very much

[kji]

You can also launch your application by using the /L parameter as in:

"C:\Program Files\Qlikview\qv.exe" /L C:\MyData.qvw