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 to lớn 64 bit excel.I cannot run the VBA file anymore.

Bạn đang xem: Cách khắc phục lỗi compile error in hidden module excel vba

It show the error:Compile error in hidden module.This error commonly occurs when code is incompatible with version, platkhung 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 Alt + F11 go inkhổng lồ its Visual Basic Editor.From the Tools menu select References ( Note, if references option is disabled in tools menu try closing and reopening tệp tin và enable Macro before proceeding next steps)Scroll through the available References List & uncheck any thành tựu start with MISSING:Press Alt + Q once all of these reference errors have been unticked.

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

This links has mentioned all troubleshooting stepshttp://www.repairmsexcel.com/blog/fix-compile-error-in-hidden-module-excel

Thanks


*

You can try to check if any missing variable declaration.I had same issue và found out that missing declaration for one variable using for looping


*

I had this issue with the first-các buổi party Solver addin that is included with Excel.The solution was to lớn use Windows 8 compatibility mode.

*

Original source


*

Thanks for contributing an answer khổng lồ Staông chồng Overflow!

Please be sure to answer the question. Provide details và mô tả your research!

But avoid

Asking for help, clarification, or responding to other answers.Making statements based on opinion; baông chồng them up with references or personal experience.

Xem thêm: Cách Làm Tăng Số Người Theo Dõi Trên Facebook Nhanh Và Hiệu Quả Nhất

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


Post Your Answer Discard

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


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


*

site kiến thiết / logo © 2021 Stachồng Exchange Inc; user contributions licensed under cc by-sa. rev2021.12.13.40988


Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and discthua thảm information in accordance with our Cookie Policy.