Export to PDF / Excel

[#1]

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

[#2]

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.

[Anonymous]

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.

[#4]

Your application is running on your QV Server no ?

Yes it is the case, do you have excel installed on that server ?

Thanks

Philippe

[#5]

No, you don't need to have Excel installed on the server.

Best regards
Stefan

[etay_netintent]

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