Scheduling Report Generation-Error
Trying to do the Scheduling report generation,But getting an error message as ActiveX component cannot create object.Please find the attachment for error message also.
I request you to help me to solve this error in scheduling report generation.
Ms office version :2016 basic 32-bit version.
Voted best answer
Is it a fresh installation or upgrade system?
ensure the following settings in the excel:
1.Disable All macros except digitally signed macros option in the Trust Center settings.
2.VBA features should be installed for office via custom installtion of office.
3.Datadirect should be add-in for 800xA service account login
1. Check whether the add-ins added in service account.
2. Have provided template and destination path in the network? If yes check the firewall.
3. Try to run a dummy report in the scheduler service provider system with template and destination within the local files. dummy reports mean empty excel.