Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can the Publisher Enterprise automatically export a PDF document or Excel file from a QlikView document before distribute it ?
If yes how ?
If no how can I do ? Maybe with scripting inside the document ?
Does anyone have this script ? If I associate the script on the open event the PDF or Excel file will be generated everytime someone open the document...so what can be do ?
Thanks a lot
Bye
Though obvious, another thing to keep in mind is that Publisher loads qvw files using the execution service using qvb.exe. This execution should be on a computer running in an account with excel installed.
I checked the Qlikview Security, the settings are correct.
It seems to fail at different lines. I think it might have something to do with Excel security. I am running MS Excel 2007?
The Qlikview model is still running in a development environment with administrator user rights and MS Excel running locally.
Your application is running on your QV Server no ?
Yes it is the case, do you have excel installed on that server ?
Thanks
Philippe
No, you don't need to have Excel installed on the server.
Best regards
Stefan
Hi
It is possible to run the macro from an external VBS file.
Place the working macro code inside the VBS file, Create a DOC object and change all of the ActiveDocument to DOC.
then olave the Cscript command to run the VBS inside a batch, and run the batch when the publisher reload ends as an external task.
We have a daily export of an excel after loading with the publisher.
Good Luck
Etay