Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
Yes Avinash this option is already selected.
Regards,
Anand
both the excel task are running on the same mode ?? i.e. both on the allow system access
Check this ;
Please check macro settings using Control+M
Hi,
If you are using the command line parameters to reload applications, use below code as parameter.
Regards,
Kaushik Solanki
Yes both are on same settings rest of the day it is working fine. But on the monthend i realized this problem.
Regards,
Anand
Thanks Kaushik,
Can you provide complete code with this switch function.
Regards,
Anand