enter image mô tả tìm kiếm hereI have a problem about excel VBA.Excel tệp tin is created for many years. It run VBA code in 32 bit excel.However, my computer nâng cấp 32 bit excel khổng lồ 64 bit excel.I cannot run the VBA tệp tin anymore.

Bạn đ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 tệp tin which is having issue, press alternative text + F11 go into its Visual Basic Editor.From the Tools menu select References ( Note, if references option is disabled in tools thực đơn try closing và reopening file và enable Macro before proceeding next steps)Scroll through the available References List and uncheck any thắng lợi start with MISSING:Press alternative text + Q once all of these reference errors have been unticked.

Xem thêm: Văn Mẫu Lớp 5: Em Hãy Tả Dòng Sông Quê Em Lớp 5 : Em Hãy Tả Dòng Sông Quê Em

If above steps does not solve issue try editing registry entries for 32/64 bit versions excel application.

This liên kết has mentioned all troubleshooting stepshttp://www.repairmsexcel.com/blog/fix-compile-error-in-hidden-module-excel

Thanks


*

You can try to kiểm tra 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 khổng lồ use Windows 8 compatibility mode.

*

Original source


*

Thanks for contributing an answer khổng lồ Stack Overflow!

Please be sure to lớn answer the question. Provide details và share your research!

But avoid

Asking for help, clarification, or responding to lớn other answers.Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.


Post Your Answer Discard

By clicking “Post Your Answer”, you agree to lớn our terms of service, privacy policy and cookie policy


Not the answer you're looking for? Browse other questions tagged excel vba or ask your own question.


*

Site kiến thiết / logo © 2022 Stack Exchange Inc; user contributions licensed under cc by-sa. Rev2022.5.19.42176


Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device và disclose information in accordance with our Cookie Policy.