logo ASAP Utilities

Answered Questions (FAQ)

If you have a question or experience a problem with ASAP Utilities then please verify if there is already an answer to your question or solution for you problem in our list of frequently answered questions.

Priority support for clients

If you can't find the answer on our website then please contact us.

Version history

A history of the various updates and improvements throughout the years

How it makes YOU rock in Excel

These short tutorials show you how to benefit from the tools in ASAP Utilities and are guaranteed to save you time and speed up your work in Excel.

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of our excel add-in

Uninstall

How to (temporary) uninstall ASAP Utilities.

Bug report

If you have found a bug first make sure you are using the most recent version. If that is the case go to our bug-report page

Debug information

In some cases you will be asked by our support-team to turn on the debug-mode to help solve specific problems.

Links

Links to interesting websites

Excel Books

The best books on Excel. Whether you want to learn Excel, write better formula's, learn how to use macros or write professionals applications in Excel these are the best books

How to solve the error: "Compile Error in Hidden Module: ASAP..."

Published: September 4, 2017 (latest revision April 1, 2022)
reference id: QA0304

Problem

If you get an error similar to "Compile Error in Hidden Module: ASAP...", then there is something wrong is missing in Excel.

We've got this reported a few times, and got reported from 2 3 users that another program, called WPS Office, could somehow corrupt Excel/VBA when that program is uninstalled.
"...the problem started soon after I installed and immediately uninstalled WPS_office Suite."

We've haven't been able to reproduce this ourselves yet, and we've got it reported from 2 3 users only, but we mention it here in the FAQ anyway.

Solution 1

In general, we would recommend a repair of your Office installation when you get a similar error:
https://support.office.com/en-us/article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

However, this is how our users fixed it:

Hi, 

So, played around a bit more...tried to get it working with office 365, same error.
Then I remembered, I uninstalled that office free application the other day, WPS. (https://www.wps.com/) as it managed to make itself the default app for a number of MS doc types. So, I uninstalled office 365, re-installed WPS, and then reinstalled Office 2013 64bit again, problem has gone away.

seems like the uninstall for WPS screwed up VBA or something else....

Thanks for your quick response earlier though... 

..don't know how I would survive without ASAP Utilities! 

Solution 2

If you also get an error message similar to "Object library invalid or contains references to object definitions that could not be found" in addition to the above error, then you might also want to verify the following:

We also found a reference about this error related to outdated extender files (*.exd) from the Microsoft Forms Control package (part of MS Office, used to display userforms, buttons, checkboxes etc.).

Please perform following steps to solve this error:
1. Close all the Microsoft Office Applications
2. Start Windows Explorer (make sure to include hidden and system files and folders)
3. Navigate to C:\Users\\AppData\Microsoft\Forms
4. Delete all the ".exd" files in this folder (they will be automatically re-created by Excel when you start it.
5. Navigate to C:\Users\\AppData\Local\Temp\VBE
6. Delete all the ".exd" files in this folder (they will be automatically re-created by Excel when you start it.
7. Reboot the computer (this is not always necessary, but better safe than sorry)
8. Restart Excel.

Automated Solution
An automated 'FixIt' solution is available from Microsoft:
KB 3025036 - "Cannot insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update
http://support.microsoft.com/kb/3025036/EN-US

Sources of this:
https://support.microsoft.com/en-us/help/3025036/cannot-insert-object-error-in-an-activex-custom-office-solution-after
https://tatvic.uservoice.com/knowledgebase/articles/203175-on-excel-open-it-shows-error-message-object-lib (page no longer available)
https://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled
http://www.lessanvaezi.com/delete-exd-files-to-fix-object-library-invalid-error/
https://www.event1software.com/kb-all-products/form-controls-stop-working-after-december-2014-updates/






« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us