- last edited on
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 when code is incompatible with the version, platform, or architecture of this application."
I am really very frustrated with this error.
Even Simple VBA code also prodcuced error e.g. I simple use Command button on the sheet and use Msgbox "Hi".
Now the probelm is that This works fine in my system. But when I send this workbook to someone else in my team then it shows the above mentioned error.
I have tried following in the users system:-
1. Delete *.EXD files in the user's temp folder
2. re-install excel and windows, the same platform I have.
I have developed N numbers of VBA automations but at some workstations my code procuded the above mentioned error and at some workstations it workes fine.
Can anyone resolve this problem?
02-19-2017 01:25 PM - edited 02-19-2017 01:26 PM
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.
02-19-2017 09:23 PM
F8 Key (next step) shows:
We all are using the Windows 8 and ms office 2013 version
02-19-2017 11:43 PM
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
02-20-2017 04:15 AM
04-27-2017 11:17 PM