Excel bị lỗi compile error in hidden module mdlgl năm 2024

Archived content

NOTE: this is an archived page and the content is likely to be out of date.

"Compile Error in Hidden Module" error message when you start Word or Excel

1. When you start Word or Excel, you receive a "Compile error in hidden module" error message. This error message appears when the translation function add-in for ATLAS in Word or Excel is not deleted after uninstalling ATLAS. There are two possible solutions listed below. .

Solution 1

Reinstall ATLAS and select ATLAS V14.0 - Tools - "Setup Application Translation" (Translation function add-in setup) from the Windows Start menu. Uncheck the box for Excel and click OK.

Solution 2

Follow the steps below to manually delete the translation function add-in.

For WORD

1. Start Windows search. Windows XP: Select "Search" - "All Files and Folders" from the Windows start menu. Windows ME, Windows 2000: Select "Search" - "Files and Folders" from the Windows Start menu.
2. In the search results window, perform the following steps and press Search. Windows XP, 2000: In the "All or Part of the File Name" or "Files or folders" fields, enter [*.dot]. In the "Look in" field, enter the drive that the OS is installed on.
3. From the search results, delete the files included in the list below. Be careful not to delete any files in \sample\coop in the ATLAS installation folder (Ex. C:\program files\ATLAS V14)

   Version of ATLAS and file to be deleted:

   • ATLAS V14: ATLAS140.dot or ATLAS_V14.dotm
   • ATLAS V13: ATLAS130.dot
   • ATLAS V12: ATLAS120.dot
   • ATLAS V11: ATLAS110.dot
   • ATLAS V10: ATLAS100.dot
   • ATLAS V9: ATLAS90.dot
4. Open Word and select Templates and Add-ins from the Tools menu.
5. If any files deleted in step 1 remain in the add-in template box select them and press Delete.

For EXCEL

1. Start Windows search. Windows XP: Select "Search" - "All Files and Folders" from the Windows start menu. Windows 2000: Select Search - Files and Folders from the Windows Start menu.
2. In the search results window, perform the following and press Search. Windows XP, 2000: In the "All or Part of the File Name" or "Files or folders" fields, enter [*.xla]. In the "Look in" field, enter the drive that the OS is installed on.
3. From the search results, delete the files included in the list below. Be careful not to delete any files in \sample\coop in the ATLAS installation folder (Ex. C:\program files\ATLAS V14)

   Version of ATLAS and file to be deleted:

   • ATLAS V14 : ATLAS140.xla or ATLAS_V14.xlam
   • ATLAS V13 : ATLAS130.xla
   • ATLAS V12 : ATLAS120.xla
   • ATLAS V11 : ATLAS110.xla
   • ATLAS V10 : ATLAS100.xla
   • ATLAS V9 : ATLAS90.xla
4. Open Excel and click the Toolbar tab in "User settings" in the Tools menu If any files deleted in step 1 remain in the toolbar box select them and press Delete. If any files named "ATLAS Vxx" appear in the toolbar box, select them and press Delete.

Are you seeing a “Compile Error in Hidden Module” message pop up in Excel? If so, you’re not alone. Many users have encountered this error while trying to use Excel and have been wondering how to fix it. In this article, we’ll discuss the causes behind this issue and how to solve it.

Compile Error in Hidden Module in Excel: This error occurs when a Visual Basic for Applications module is missing or damaged. To fix this error, you need to go to the Control Panel, select COM Add-Ins, and delete any references to the missing or damaged module. If the error persists, you can also try running the repair utility in Excel, or reinstalling the program.

What is a Compile Error in Hidden Module in Excel?

Compile error in hidden module is an error that occurs when a macro or user-defined function attempt to access a Visual Basic (VB) project within a Microsoft Excel workbook. The error occurs when the macro or function is unable to access the VB project and therefore cannot locate the necessary code to execute. This can be caused by a variety of issues, such as a missing or corrupted VB project, or a mismatch between the version of Excel and the version of the VB project.

The most common symptom of this type of error is the appearance of a pop-up window that reads “Compile error in hidden module” and the name of the module that generated the error. This window will typically appear when the user attempts to open the workbook or execute a macro or user-defined function. The error message may also include a reference to the name of the module or the line of code that caused the error.

What Causes Compile Error in Hidden Module in Excel?

Compile error in hidden module can be caused by a variety of issues, including the following:

-A mismatch between the version of Excel and the version of the VB project. -A missing or corrupted VB project. -The presence of a macro or user-defined function within the workbook that is attempting to access a non-existent VB project. -A problem with the settings of the VB project.

The exact cause of the error can be difficult to determine, as there can be a variety of potential causes. Therefore, it is important to identify the specific cause of the error so that it can be corrected.

How to Fix Compile Error in Hidden Module in Excel?

In order to fix a compile error in hidden module in Excel, it is important to identify the exact cause of the error. Once the cause of the error has been identified, it is then possible to take steps to fix the issue.

Check the Version of Excel and the VB Project

The first step to solving a compile error in hidden module in Excel is to check the version of both Excel and the VB project. If there is a mismatch between the two, then this can cause the error to occur. If this is the case, then the user should ensure that both the Excel and VB project are of the same version.

Check the VB Project Settings

If the version of Excel and the VB project are the same, then it is possible that there is an issue with the settings of the VB project. The user should check the settings of the project to ensure that it is properly configured. If there is an issue with the settings, then the user should make the necessary changes to correct the issue.

Check for Corrupted or Missing VB Project

If the version of Excel and the VB project are the same, and the settings of the project are correct, then it is possible that the VB project is corrupted or missing. The user should check to make sure that the VB project is present in the workbook and that it is not corrupted. If the VB project is missing or corrupted, then the user should attempt to restore it from a recent backup.

Check for Macros or User-Defined Functions Accessing Non-Existent VB Project

If the version of Excel and the VB project are the same, the settings of the project are correct, and the VB project is not corrupted or missing, then it is possible that there is a macro or user-defined function within the workbook that is attempting to access a non-existent VB project. The user should check for any macros or user-defined functions that are attempting to access a VB project and remove them if necessary.

Top 6 Frequently Asked Questions

What is a Compile Error in Hidden Module in Excel?

A Compile Error in Hidden Module in Excel is an error message generated by Microsoft Excel when the user attempts to open a document containing VBA (Visual Basic for Applications) code. The error indicates that the code is not properly compiled, and therefore cannot be executed. This error can occur when the VBA code is corrupted or invalid, or if a file or module referenced in the code is missing or corrupt.

What Causes Compile Error in Hidden Module in Excel?

A Compile Error in Hidden Module in Excel can be caused by a variety of issues, including corrupt or missing files, invalid VBA code, or corrupt or missing modules. Additionally, third-party software that adds VBA code to a document can cause the error to appear.

How Can I Fix a Compile Error in Hidden Module in Excel?

The first step in fixing a Compile Error in Hidden Module in Excel is to identify the source of the error. The best way to do this is to check the VBA code for any errors or missing files. Additionally, the user should check for any third-party software that may be adding VBA code to the document. Once the source of the error has been identified, the user can then take steps to fix it, such as replacing missing files, repairing corrupt files, or removing any third-party software.

What Are the Common Symptoms of a Compile Error in Hidden Module in Excel?

The most common symptom of a Compile Error in Hidden Module in Excel is an error message that appears when the user attempts to open a document containing VBA code. Additionally, the user may see the document open but find that the VBA code does not execute properly. In some cases, the user may see an error message when attempting to save the document.

What Are the Possible Consequences of a Compile Error in Hidden Module in Excel?

If a Compile Error in Hidden Module in Excel is not fixed, then the user may find that the VBA code in the document does not execute properly, or the document may fail to open at all. Additionally, the user may find that any changes they make to the document are not saved.

Are There Any Tools That Can Help Fix a Compile Error in Hidden Module in Excel?

Yes, there are several tools available that can help to diagnose and fix a Compile Error in Hidden Module in Excel. These tools typically check for any missing or corrupt files, check for any invalid VBA code, and can even detect and remove any third-party software that may be adding VBA code to the document. Additionally, some of these tools can also help to repair any damaged or missing files.

Fix Compile error in hidden module in Excel/Word on Windows

In conclusion, a Compile Error in Hidden Module in Excel can be a frustrating experience for those who use the software. However, with the proper steps and guidance, you can quickly and easily resolve the issue and get back to work. With the right knowledge and tools, you can make sure that the problem is resolved quickly and efficiently.