Forum Discussion

Copper Contributor

Feb 17, 2017

VBA Excel Code Compatible Error

Hi, I am facing the below mentioned error, The VBA code run perfectly in my system, While using the same macro to another system it shows the below mentioned error: "The error commonly occurs...

Excel Desktop

Macros & VBA

IngeborgHawighorst

MVP

Feb 19, 2017

What suggestions do you get when you click the Help button in that error message?

What happens if you step through the code on the other person's machine?

What is your OS and Excel version exactly?

What is the other person's OS and Excel version exactly? Don't just say "the same". Detail it.

Arvind Kaushik

Copper Contributor

Feb 20, 2017

Hi,

F8 Key (next step) shows:

We all are using the Windows 8 and ms office 2013 version

Regards,

Arvind

IngeborgHawighorst
MVP
Feb 20, 2017
Here's something you can try:

In the VBA editor launch the Compile command from the menu and then check the References dialog to see if there is anything missing and if so try to add these libraries.
In general it seems to be good practice to compile the complete VBA code and then saving the document before distribution.

source (and other suggestions at): http://stackoverflow.com/questions/507191/cant-find-project-or-library-for-standard-vba-functions
- Arvind Kaushik
  Copper Contributor
  Feb 20, 2017
  Thanks A lot, I never tried this option, I will try this and let you know if error still persist.