Execute Command - Open a Excel Document

BouwerVa — Wed, 27 Nov 2019 08:03:21 GMT

Can one use the Execute Command to Open a specific Excel Document.

If so how would one do this?

The Excel File I want to open is .xlsm

Re: Execute Command - Open a Excel Document

marcus_sommer — Wed, 27 Nov 2019 08:34:07 GMT

In general yes: Run-Excel-macro-via-QMC

- Marcus

Re: Execute Command - Open a Excel Document

Brett_Bleess — Tue, 10 Dec 2019 14:00:47 GMT

Need some further clarification on this one if Marcus' comment did not help. Are you wanting to run this from the Desktop Client only or also from Publisher? If just the Desktop, the key is to enable the execute option, which you can do in the Script editor of the QVW in question, go to the Settings tab in the Script Editor and check the Can Execute External Programs check box, that will allow the Execute function call in the script:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Execute.htm

That should cover everything I believe. Shout if you have further questions, or I have misunderstood the question.

Regards,
Brett

topic Re: Execute Command - Open a Excel Document in QlikView

Execute Command - Open a Excel Document

Re: Execute Command - Open a Excel Document

Re: Execute Command - Open a Excel Document