Fruitsekta.ru

Мир ПК
6 просмотров
Рейтинг статьи
1 звезда2 звезды3 звезды4 звезды5 звезд
Загрузка...

Excel compile error in hidden module

При запуске надстройки, появляется сообщение об ошибке

Рассмотрим несколько наиболее часто встречающихся ошибок.

при открытии файла программы, выскакивает сообщение
Compile error in hidden module: mod_*

Основная причина такой ошибки, — вы пытаетесь запустить надстройку в Excel для MAC

Надстройки работают только в Excel и только под Windows, — потому, если вы являетесь счастливым обладателем Мака,
и хотите использовать мои надстройки, — установите Parallels, и запускайте надстройки из-под Windows
(проверено: на Маке, под Parallels, всё работает)

Возможна другая причина ошибки, — вы используете старую версию Office (например, Excel 2002/XP)

Все надстройки гарантированно работают (если это не оговорено отдельно) в версиях Excel, начиная с 2003.
Установите офисный пакет посвежее, — и всё заработает.

Если эта ошибка появляется в надстройке Parser — ознакомьтесь с этой инструкцией

Редко, но может быть и другая причина, — я допустил ошибку в программе.

Обычно я устраняю подобные проблемы в течение нескольких минут (заливая на сайт исправленную версию файла), — но, бывает, пользователи успевают скачать некорректный файл.
Если у вас используется Windows и Excel версии от 2003 и выше, а ошибка «Compile error in hidden module», тем не менее, появляется, — сразу сообщите мне об этом любым способом (по Скайпу или почте)

при открытии файла программы, появляется сообщение
Для этой книги недоступны проект VBA, элементы управления ActiveX и остальные программные средства

Если вы увидели такое сообщение, — попробуйте запустить любой другой файл с макросами
(например, любую другую программу с моего сайта)

Если и другие файлы с макросами вызывают такую ошибку, — значит, у вас не установлен (или некорректно установлен) компонент Office «Microsoft Visual Basic»

Такое бывает, когда при установке Office пользователь сам выбирает нужные ему компоненты, часто отключая пункт «средства Office»,
среди подпунктов которого и находится «Microsoft Visual Basic» — модуль поддержки макросов в офисных приложениях.

Решается проблема просто, — надо доустановить указанный компонент.
Для этого, заходим в Панель управления — Установка и удаление программ, находим и выделяем в списке программ Microsoft Office, нажимаем кнопку Изменить, — и в разделе «средства Office» для компонента «Microsoft Visual Basic» выбираем вариант «Запускать с моего компьютера».
Несколько минут, — и ваш Excel научится понимать макросы. После этого, ошибка перестанет появляться.

Если же другие файлы с макросами нормально работают (эта ошибка не появляется), — значит, используемый вами файл повреждён.

В этом случае, удалите файл надстройки, и заново скачайте последнюю версию со страницы программы.

Compile Error in HIdden module?

LinkBack
Thread Tools
Rate This Thread
Display
  • Linear Mode
  • Switch to Hybrid Mode
  • Switch to Threaded Mode

Compile Error in H >

Ok I’ve created a database of sorts with user login, userforms .. the whole 9. (with the help of this site) THANKs!!

However, depending on who tries to open the file they can get a message :

Compile errror in hidden module: sheet1
Compile error in hidden module: userform1

I am working with excel 2003 sp2

The people who get error messages are working with excel 2003 (no sp) & excel 2003 sp3.

I am working with excel 2003 sp2.. and do not get this message, others with lower version do not get it either.

Is there some download for this?

You mention that there is a difference in SP level between your excel and the excel used by people that get the error message.
The error could be caused by a library reference that you do have and they don’t.

If you open a module in the Visual Basic Editor you can check the library references by selecting the menu option Extra -> References

I would advise to compare these. It could be that one of the references is ‘MISSING’ or maybe there is another difference.

Читать еще:  Работа в excel обучение для начинающих

Compile Error in H >

I’m having a similar issue:

I developed an excel file with macros and VBA in Excel 2002 (SP3). Another user has Excel 2007. He is receiving MICROSOFT VISUAL BASIC — COMPILE ERROR IN HIDDEN MODULE: MODULE 2

The MODULE2 includes sheet selects, range selects, unprotect/protect sheets with password, copy, paste, sort. For Each and If

If the user does not have the library reference selected, is there a way to «Do it for them?» The plan is to have this as a tool with students and I would prefer to avoid walking them through steps in VBA project to select the library reference.

Since I have the VBA project password protected, is there a way to have the user select/save the library reference choices before opening the excel file so that it will work accordingly?

Thanks for the help!!

Since I have no experience with excel 2007 I cannot help you on this one, but maybe if you search in google you can find some useful information.

I myself have not yet found a way to solve this missing link issue automatically based on the environment the workbook is used in.

So until now the only option I see is that you change the references manually. but once you have done that for one copy under Excel 2007, you can distribute that one to other 2007 users. I guess they will not have any problems with that version.

I’m getting closer and will share what I’ve found, but I also need a little more help to ‘massage’ it for full functionality.

I put the attached code in ThisWorkbook based on a suggestion. Question — what is the difference between ThisWorkbook and Module? If you use ThisWorkbook, will it or can you have it run automatically onopen?

The first Function updates the security to be VBATrusted.
The AddReference sub provides code to add a reference that is not version specific. It uses the GUID for the reference library, thus the 10.0 or 11.0 after the reference library name will not come into play.

Question — does anyone know if you can have it add mutliple references in the AddReference Sub? I would like to add all that I have in mine to be sure.

Question — I had Microsoft Calendar Control 10.0 checked. The 2007 version said it was missing and required Microsoft Works Calendar 5.0 Type Library checked to get it to run. Does anyone know how to choose this GUID or ensure it’s selected correctly?

Code from several VBA Express Knowledge Base entries (give credit where credit is due)

Repairing Compile Error in H > Uchenna / No Comments

Читать еще:  Срзначесли в excel

Depending on which application has crashed, you may see references to word.exe or excel.exe, but ultimately, it’s the same issue, with the same set of instructions to rectify.

What Causes Compile Error in Hidden Module?

The most common cause for this error is said to be due to the Microsoft Office Startup folder containing one or two particular add-in template files that are required by Adobe Acrobat PDF Maker, these files are as follows:

Additionally, a software conflict between Microsoft Office and Norton Anti-virus software is also known to cause this error.

Fixing This Error

Fixing this error is integral to ensuring that both Microsoft Word and Excel are able to startup as they should and run optimally. Below are a number of methods that have all proven effective at rectifying this problem.

Reregister OCX Files

In addition to the previously mentioned causes, this error is also known to manifest itself after a Windows update. With that said, an effective way of fixing this problem involves reregistering a few files integral to the functionality of Word or Excel. To do this, simply do the following:

1. First, boot into your computer with administrative rights.

2. Once in, press + R, type cmd and click on OK.

3. Once Command Prompt loads up, depending on your version of Windows (whether it’s 32bit or 64bit), type the following:

regsvr32 -u c:windowssystem32mscomctl.ocx
regsvr32 c:windowssystem32mscomctl.ocx

regsvr32 -u c:windowssyswow64mscomctl.ocx
regsvr32 c:windowssyswow64mscomctl.ocx

Note: Make sure you press Enter, after each line.

4. Then try running Microsoft Word or Excel again.

Delete .exd Files

Usually reregistering the above mentioned files is enough to fix the compile error in hidden module issue; however, if that doesn’t do the trick for you, then you should consider deleting two specific files from your application data folder. The instructions on how to do this are as follows:

1. First, ensure you’ve booted into your computer with administrative rights.

2. Then press + R, type %appdata% and click on OK.

3. This will take you to the Application Data Folder, from here, double click on Microsoft.

4. Then double click on Forms.

5. Lastly delete comctllib.exd and mscomctllib.exd (if they exist) by right clicking on them and selecting Delete.

Update Adobe Acrobat

If the method mentioned above didn’t fix the problem, then you should look into updating your version of Adobe Acrobat. To do this, simply visit the Adobe website, locate and download the latest update for your Adobe Acrobat application. Then restart your computer and check whether or not this has fixed the problem.

You should be able to find the latest updates by doing a searching for Adobe Acrobat Updates in your search engine.

Читать еще:  Excel цикл по ячейкам

Update Norton Anti-Virus

There is that possibility that the error is being caused by the Symantec software on your computer. If that is true in your case, then you will need to download and install the latest update for it.

Support on how to successfully update your software can be found on the Symantec website, which should show you how to navigate any potential problems.

Once you have updated your software, make sure you restart your system, as this will finalize the process, by removing any unnecessary installation files from the system. The compile error in hidden module problem should be rectified, if it was caused by the Symantec products on your computer.

You may also want to look into uninstalling any Symantec products on your computer. To do this, simply locate the uninstall package in your Start menu, under All Programs. You should also be able to remove the application(s) from the Add or Remove Programs wizard; for more information on how to access and utilise this tool, I suggest you check out my post on fixing runtime error 1004.

Note: It’s very important that you have an anti-virus tool running on your computer. Thus, if you remove the Symantec products from your computer, including your anti-virus tool, then it’s very important that you have an alternative to keep the system secure.

For additional help on alternatives to the Norton Anti-virus tool, I recommend you check out my post on the best antivirus tools.

Apply Service Pack

The compile error in hidden Module issue you are experiencing may be due to an outdated installation file in your computer. Typically, if you have Windows update set to auto-update then it will automatically download the latest updates for the Microsoft Office applications on your computer. However, if you have only recently installed Microsoft Office 2007 on your computer, you should download and apply the latest service pack for it.

Move Startup Folder Files

The last option involves moving the files from the startup folder of the specific Microsoft Office application that is reporting the error. You will need to remove both the Pdfmaker.dot and Pdfmaker.xla files to another location on your computer.

To accomplish this task, simply do the following:

1. First, ensure you have booted into your computer with administrative rights.

2. Then click on Start -> Search [ Windows Vista/7/8/8.1 : Start -> Type pdfmaker.* (into the Search programs and files box) and Press Enter] [ Windows Vista/7 : Type pdfmaker.* in the Search Windows box].

3. From the Search Results page, click on all files and folders.

4. Then type pdfmaker.* into the All or part of the file name box and click on Search.

5. Once it has located the files, right click on pdfmaker.dot and pdfmaker.xla, and select Cut.

6. Then right click on your Desktop and select Paste.

Note: This will move the files to your desktop. Alternatively, if you don’t use the PDF conversion templates, then you can delete them.

Are you looking for a way to repair all the errors on your computer?

If the answer is Yes, then I highly recommend you check out Advanced System Repair Pro.

Which is the leading registry cleaner program online that is able to cure your system from a number of different ailments such as Windows Installer Errors, Runtime Errors, Malicious Software, Spyware, System Freezing, Active Malware, Blue Screen of Death Errors, Rundll Errors, Slow Erratic Computer Performance, ActiveX Errors and much more. Click here to check it out NOW!

Ссылка на основную публикацию
Adblock
detector