Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi
create a macro
sub reload
ActiveDocument.Reload
end sub
and set it to run on open document
regards
Peter
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
You can also launch your application by using the /L parameter as in:
"C:\Program Files\Qlikview\qv.exe" /L C:\MyData.qvw