Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
BouwerVa
Contributor II
Contributor II

Execute Command - Open a Excel Document

Hi

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

2 Solutions

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Brett_Bleess
Support (Former)
Support (Former)

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/Scrip...

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

Brett_Bleess
Support (Former)
Support (Former)

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/Scrip...

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.