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: 
its_anandrjs

Task goes to Safe Mode.

Dear Friends,

Need some help from you i experience some problems in one project which is related to Win task scheduler.

1. There is 2 schedulers run for Excel macros.

2. Some times it goes to the safe mode from Allow system access.

Problem here is some time the macro goes to safe mode due to that the application not run until user click on the button. Due to this the win task scheduler not run and next schedule time comes again and the previous not closed due to that next one also not run.  

Regards,

Anand

10 Replies
avinashelite

Did you tried this :

>User Preferences and in the Security tab tick the option to Always Override Security in the Module (Allow CreateObject and File Access).

avinashelite

macro override.JPG.jpg

its_anandrjs
Author

Yes Avinash this option is already selected.

Regards,

Anand

avinashelite

both the excel task are running on the same mode ?? i.e. both on the allow system access

agni_gold
Specialist III
Specialist III

Please check macro settings using Control+M

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

If you are using the command line parameters to reload applications, use below code as parameter.

Capture.PNG

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
its_anandrjs
Author

Yes both are on same settings rest of the day it is working fine. But on the monthend i realized this problem.

Regards,

Anand

its_anandrjs
Author

Thanks Kaushik,

Can you provide complete code with this switch function.

Regards,

Anand