Feb 17 2017
03:11 AM
- last edited on
Jul 25 2018
09:33 AM
by
TechCommunityAP
Feb 17 2017
03:11 AM
- last edited on
Jul 25 2018
09:33 AM
by
TechCommunityAP
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 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?
Regards,
Arvind Kaushik
Feb 17 2017 03:38 AM
Hi,
I am attaching the Error Screenshot...
Regards,
Arvind Kaushik
Feb 19 2017 01:25 PM - edited Feb 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.
Feb 19 2017 09:23 PM
Hi,
F8 Key (next step) shows:
We all are using the Windows 8 and ms office 2013 version
Regards,
Arvind
Feb 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
Feb 20 2017 04:15 AM
Apr 27 2017 11:17 PM
Jul 03 2019 09:21 PM
@Chip Pearson - Please let me know if you have found any solution.