BCHCAdmin
asked on
Excel 2013 error opening file with macros
I have a user running Excel 2013 that is getting an error when they open a workbook that has Macros. They get a Microsoft Visual Basic for Applicatoins window and the error is:
-------
Compile error in hidden module: MOdule 1. This error commonly occurs when code is incompatible with the version, platform or architecture of this application. Click "Help" for information on how to correct this error.
------
Not finding much on this error. Can anyone help? By the way, it opens fine on my computer running Excel 2013 as well.
-------
Compile error in hidden module: MOdule 1. This error commonly occurs when code is incompatible with the version, platform or architecture of this application. Click "Help" for information on how to correct this error.
------
Not finding much on this error. Can anyone help? By the way, it opens fine on my computer running Excel 2013 as well.
ASKER
This was an excel file sent to us by our accounting firm. We did not create it. Would we still go through same steps?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In order to check the same go to tools-->references (In Visual basic) Screenshot attached...
This will open a below mentioned dialogue box.. In this the reference which are missing will start with missing and the particular library...
If you are not using it..you will be able to uncheck it..However if you are using it..then please install the necessary library or software and post that your code will work..
Saurabh...