enter image description hereI have a problem about excel VBA.Excel file is created for many years. It run VBA code in 32 bit excel.However, my computer upgrade 32 bit excel to 64 bit excel.I cannot run the VBA file anymore.
Đang xem: Fix: compile error in hidden module in word and excel
It show the error:Compile error in hidden module.This error commonly occurs when code is incompatible with version, platform or architecture of this application.
Is that any solution. Thanks.
I have resolved same error by following these 4 steps :
Open Excel file which is having issue, press Alt + F11 go into its Visual Basic Editor.From the Tools menu select References ( Note, if references option is disabled in tools menu try closing and reopening file and enable Macro before proceeding next steps)Scroll through the available References List and uncheck any item start with MISSING:Press Alt + Q once all of these reference errors have been unticked.
If above steps does not solve issue try editing registry entries for 32/64 bit versions excel application.
This link has mentioned all troubleshooting stepshttp://www.repairmsexcel.com/blog/fix-compile-error-in-hidden-module-excel
You can try to check if any missing variable declaration.I had same issue and found out that missing declaration for one variable using for looping
I had this issue with the first-party Solver addin that is included with Excel.The solution was to use Windows 8 compatibility mode.
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.
Xem thêm: Lỗi Không Cài Được Itunes Trên Win 8 64Bit & 32 Bit”, Cách Cài Itunes Trên Máy Tính Windows 10, 7, 8
To learn more, see our tips on writing great answers.
Post Your Answer Discard
Not the answer you're looking for? Browse other questions tagged excel vba or ask your own question.
Site design / logo © 2022 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2022.5.19.42176