When trying to update or create new schedules with Excel2R, those types of errors occurs:


Solution


These COM errors occur when Excel registry folders are corrupted, or some are missing, usually, it's enough to repair Microsoft Office to fix that.

 

For "Office": Right-click on Windows logo in the taskbar > Apps and Features > Locate Office from the list > Advanced options > Repair:



For "Office 365": navigate to Apps and features, locate your "Office 365", and select Modify > Quick repair.




After that, restart your workstation and try to use Excel2R.