Tech's Magic is one stop online tutorial offers technical article based on expert's assistance and news in all technological sectors including Windows, Mac, and many more. Sep 29, 2014 It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams.Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
I'm creating a simple report excel where it merge xls files when user select a folder. It was working perfectly until when i test in different PC, i got ' Compile Error in Hidden Module' error. Below is the screenshot of the error. Below are the MergeSheets module codes that i got from internet.
I managed find the source of problem which is the incompatibility of 32bit and 64bit OS. And i managed to find the solution where i need to include PtrSafe into my declare part. After i include the 'PtrSafe' as below, the error is not showing up anymore.
However when i execute the code, my Excel program crash. Although this code is created for 32bit OS, it is working when i developing on my PC which is 64bit version. I even tried the same code on 2nd PC which also 64bit. However when i tried on 3rd PC which also 64bit, the error showed up. Hope you give can give idea for this. Thanks. **Update -Seems that the 3rd pc is using Office 64bits thus not working. -I even changed all the pointers to LongPtr. after change i get new error which is 'Run-time error '1004' Cannot run macro'.
Symptom
After installing Office Connector, you open Excel and the following error message is immediately displayed:
Compile Error Hstbarpublic
Compile error in hidden module: cSinker <OK> <Help>
Cause
This error is known to occur in the following versions of Excel (which are not supported):
Excel 2000 and prior.
Excel 2010, 64-bit version. Only the 32-bit version of Excel 2010 is supported.
Resolution
Check the System Requirements page for Office Connector to determine which versions of Excel are supported and use Office Connector in one of the supported environments.
2016 Excel For Mac Compile Error In Hidden Module Sheet 3
Compile Error In Hidden Module
If you are using a supported environment and are encountering this error, click here to contact technical support for further assistance.