How to fix KB00804 – VBA Errors in Microsoft Excel?

excel

Issue:

This KB combines and replaces the information that was found in these other KBs:

  • KB00364 – PI add-ins to Excel not available with various VBA errors after upgrading to Office 2010.
  • KB00267 – Run-time error ‘459’: Object or class does not support the set of events” or “Compile Error in Hidden module: Main” error message appears when opening Excel installed with PI Data Link.
  • KB00526 PI Data Link error: Object library invalid or contains references to object definitions that could not be found.
  • KB00631 PI Data Link Error: “System Error &H80040111 (-2147221231). Class Factory cannot supply requested class.

Read more

How To Repair Runtime Error 1004 in Excel?

Runtime Error 1004 in Excel

 Summary:

In this post, I have included the complete information about Excel runtime error 1004. Besides that I have presented some best fixes to resolve runtime error 1004 effortlessly.

To fix Runtime Error 1004 in Excel you can take initiatives like uninstalling Microsoft Work, creating a new Excel template, or deleting The “GWXL97.XLA” File. If you don’t have any idea on how to apply these methods then go through this post.

Here in this article, we are going to discuss different types of VBA runtime error 1004 in Excel along with their fixes.

Read more