Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
anil_kumar_bt
Partner - Contributor
Partner - Contributor

Run Excel macro via QMC

Hello all,

Could anyone please tell me "Is it possible to run macro in excel via QMC".

We have one excel and it contains several macros, right we have running the macro manually when open the excel file.

To automate this process we had thought like create qmc task to run the Macro.

If quick help will be much appreciated.

12 Replies
marcus_sommer

The QMC user may not have the proper access rights and/or licences/configurations to perform the task. To exclude some of the potential issues do it again with the desktop client on the server-machine with the services users.

mingsum214
Partner - Contributor III
Partner - Contributor III

Tried the service user approach, same scenario - QV desktop work and QV server reload, for QV server we found EXCEL.exe stuck in process and unable to close.

marcus_sommer

Very likely is there any popup within the Excel asking to login or for configurations like the default file-format or any other stuff which gets no respond and/or the execution of macros is restricted and/or linked content couldn't be resolved or ... a lot of possibilities. One way to exclude many of them would be to perform the entire Excel stuff manually - again on the server machine and with services user. Further within the Excel macro you should set the visibility and the responds of any kind of errors/messages to true to see what happens and where it may break.