Compile Error In Hidden Module Modaddin Excel
Contents |
are ground flat anddeleting the Forms folder didn't work for you. You're in luck: a guy who goes by GJBenzie wrote in and provided a solution that worked for my Windows Vista 32-bit and here it is: Try This for Getting Rid of modAddin Errors 1. Go to excel compile error in hidden module thisworkbook Start > Run 2. Type cmd 3. At the prompt, type: regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX 4. Hit
Excel Compile Error In Hidden Module Autoexecnew
Enter 5. Then type: regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX 6. Hit Enter Did that work for you? If you use OSI PI, check out: Want to never deal excel compile error in hidden module solver code with this problem again? Labels: DataLink, Excel, OSI PI, OSIsoft PI 30 comments: Anonymous said... Great! This worked for us. MS Office 2007 with PI ProcessBook Datalink add-in for Excel.Thank you. September 10, 2012 at 7:06 AM John Read said...
Excel Compile Error In Hidden Module Module 1
This worked. No more alarm messages. Thanks September 12, 2012 at 9:55 AM John Read said... The suggested action did the job, no more alarm messages. Thanks. September 12, 2012 at 9:57 AM Anonymous said... MS Office 2003, worked for OSI DataLink addin ... THANKS! September 27, 2012 at 1:34 PM Anonymous said... Those error messages were really annoying. This worked and they're gone now. Thank you! ~Andrew October 13, 2012 at 1:22 PM Anonymous said... thanks for sharing....resolved the excel 07 excel compile error in hidden module global macros w/ pi data link 3.1.6 issue. November 15, 2012 at 11:51 AM Anonymous said... As the September 10, 2012 commentor said: Great! This worked for me. Window XP, MS Office 2007 with PI ProcessBook Datalink add-in for Excel. November 28, 2012 at 1:24 PM Anonymous said... I had this problem with XP and Excel 2007 with PI ProcessBook Datalink add in. I had error messages both when I open and also when I closed Excel. This solved it all. Thanks a lot November 30, 2012 at 5:44 AM Anonymous said... cool!! Great!! i love you!!thank you so much! January 17, 2013 at 12:24 PM Anonymous said... thank you so much! it was really usefull January 19, 2013 at 4:55 PM Anonymous said... Yes - I also have PI Datalink installed and this worked January 22, 2013 at 2:44 PM TheCookieMonster said... Thanks! January 25, 2013 at 2:42 AM Anonymous said... Got a reply:DLLRegisterServer in c:\windows\system32\mscomctl.ocx failed. Return code was: 0x8002801cIs this because i'm not an admin on my company computer? February 15, 2013 at 8:42 AM Anonymous said... Anonymous 2/15/13: You might need to run cmd as an administrator, as you guessed.Go to Start > All Programs > AccessoriesThen right-click on Command Prompt, and select "Run as administrator".Follow the steps outlined above, and it should work. (I had the same issue as you did, and it worked for me.) February 21, 2013 at 6:49 AM Anonymous said... After the last bulk of
or outdated Difficult to follow Other Comments:(Max 1000 chars) Would you like a response? Email is required. Email: KB00804 - VBA Errors in Microsoft Excel Product: PI BatchView / PI DataLink / PI
Excel Compile Error In Hidden Module Sheet1
Tag Configurator Version(s): All Platform: Windows English German Spanish French Japanese Korean Portuguese
Excel Compile Error In Hidden Module Solvercode
(Brazilian) Russian Chinese (Simplified) Issue As you use Microsoft Excel with one or more PI add-ins enabled (PI compile error in hidden module excel 2010 DataLink, PI Tag Configurator, or PI BatchView for Excel), you may encounter one of the Microsoft Visual Basic for Applications errors below. You may also see these errors when you open Microsoft Excel http://blog.zymergi.com/2012/08/compile-error-in-hidden-module-modaddin.html or use certain functions within the add-ins, such as the Insert Trend function in PI DataLink. Could not load an object because it is not available on this machine Compile error in hidden module: modAddin Compile error in hidden module: Main Object library invalid or contains references to object definitions that could not be found Run-time error ‘459’: Object or class does not support the set of https://techsupport.osisoft.com/troubleshooting/kb/kb00804 events System Error &H80040111 (-2147221231). ClassFactory cannot supply requested class PI Excel add-ins make use of certain Microsoft-provided ActiveX controls. When there are problems with these controls, add-ins which use these controls will encounter them and produce errors. These error messages may also be caused by the Microsoft security patches, such as MS12-060. See KB00686for more information. Solution These errors are often related to a malfunctioning Microsoft ActiveX control used by an add-in, or by old cached VBA files. The following steps may help to resolve this issue. Verify required prerequisites and settings Make sure that the add-ins and related items are installed properly. For example, if the PI SDK is not installed, that will affect many of the PI add-ins. Confirmthat the ActiveX controls are enabled (not disabled). In Excel select File> Options> Trust Center> Trust Center Settings> ActiveX Settings. This should NOT be set to 'Disable all controls without notification'. Check for cached *.exd files Search for all files (including hidden files) with the extension *.exd. (By default, Windows does not search for hidden files, so you must change that setting to see them.) These .exd files are created automatically but are not cleaned up automatically.
& Alerts Release Announcements Alerts Alerts Number Date▼ Alert 0–0 of 0 articlesPage Loading... Enabling Operational Intelligence Privacy Legal Copyright Contact Us
PI ProcessBook 2.2 or later on a machine with Office XP, PI Datalink and PI Tag Configurator display this error:Compile error in hidden module: PIDL_APIandCompile error in hidden module: modAddinThe problem is that ProcessBook installs an older version of the Microsoft Office Object Type Library, which is not compatible with Office XP.WorkaroundOpen one of the other Office products (i.e., MS Word) that has VBA and open the VBA Editor. This should cause the Microsoft Office XP Setup to run again, and repair the overwritten DLL with the current, correct version. After the setup has finished, Excel can be opened and the PI Datalink and PI Tag Configurator add-ins should work fine. Enabling Operational Intelligence Privacy Legal Copyright Contact Us