Compile Error Automation Error Excel 2010
Contents |
here for a quick overview of the site Help Center Detailed answers to any
Compile Error In Hidden Module Excel 2010
questions you might have Meta Discuss the workings and policies of compile error in hidden module excel 2010 windows 7 this site About Us Learn more about Stack Overflow the company Business Learn more about
Compile Error In Hidden Module Excel 2010 Windows 7 64 Bit
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow compile error in hidden module solvercode excel 2010 is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA “Automation Error” due to Jan 2016 Office Update, probably caused by MSCOMCTL.OCX (Microsoft Windows Common Controls 6.o (Service Pack 6)) up vote 8 down vote favorite 2 EDITED ONCE excel 2010 compile error in hidden module thisworkbook SOLUTION WAS FOUND: I have added a Treeview Active X Control to one of our spreadsheet, using Microsoft Windows Common Controls 6.0 (Service Pack 6), i.e. MSCOMCTL.OCX which lives in c:\Windows\SysWOW64\ KB2881029 (Security Update for Microsoft Office 2010 32-Bit Edition) (MS16-004), pushed out from Microsoft on the 15/01/2016 (or thereabout), installs a new MSCOMCTL.OCX (version 6.1.98.46 which was "Created" 9/12/2015, but "Accessed" (i.e. installed on the computer) at the time of the update). This made the workbook "loose" reference to MSCOMCTL.OCX (quote marks on "loose", because the reference is still ticked but no longer works, the workbook doesn't compile because of "Compile error: Object library feature not supported" or "Automation error") It seems that the update modifies the registry key HKEY_CLASSES_ROOT\TypeLib{831FDD16-0C5C-11D2-A9FC-000F8754DA1}\ by adding a SubKey 2.0, but leaves it empty, and doesn't register the new MSCOMCTL.OCX. Fixing the problem requires 3 steps: 1) MSCOMCTL.OCX. needs to be un-registered and re-registered (Start button/search/command/right click command prom
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring
Compile Error In Hidden Module Excel 2013
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question excel compile error can't find project or library x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join
Excel Compile Error Method Or Data Member Not Found
them; it only takes a minute: Sign up Excel/VBA Automation Errors due to Office Service Pack 3.0 caused by Forms up vote 6 down vote favorite 4 After installing all latest windows updates my Excel VBA code is showing an http://stackoverflow.com/questions/34803843/excel-vba-automation-error-due-to-jan-2016-office-update-probably-caused-by-m automation error at the very start of the first module. It contains some forms as well as numerous modules of VBA code. However, when removing the forms (and associated code) everything is fine. The same thing happened about a year ago after some other windows updates. Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different. What is going on and how can I get the forms to http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3-0-caused-by-forms work? All the code is unchanged and has survived all previous windows/office updates. Running Windows 7 (same happening on Vista machine) and Office 2007. windows excel vba ms-office windows-update share|improve this question asked Aug 15 '12 at 14:38 Rob 4343716 add a comment| 11 Answers 11 active oldest votes up vote 16 down vote accepted I used to see this a lot with Visual Basic and Crystal Reports; either due to a bad deployment or DLL Hell. So, my guess is that it's not the code but perhaps some 3rd party controls (OCXs, DLLs) you're using. Check your References (In VBA IDE, click Tools and References) and to see where each DLL is pointing. See if any of the dates on the libraries are different than a working machine and you may find the culprit. Edit The OP found the problem by following the steps above. The fix for this particular issue is to unregister mscomctl.ocx: regsvr32 /u mscomctl.ocx Then register it: regsvr32 mscomctl.ocx share|improve this answer edited Aug 16 '12 at 9:57 answered Aug 15 '12 at 14:52 ray 4,68942748 Not straight forward to compare, but only key difference I found is "Microsoft Windows Common Controls 6.0 (SP6) MSCOMCTL.OCX which is dated 6/6/12 on the updated (and not working) machine and 4/11/11 on an "old" one. Not using any 3rd party controls and all worked fine until windows updates ran. –Rob
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Excel 2010 VBA - Automation Error - Unspecified Error Want to Advertise Here? Solved Excel 2010 https://techsupport.osisoft.com/Troubleshooting/KB/KB00686 VBA - Automation Error - Unspecified Error Posted on 2012-08-20 MS Applications MS Office MS Excel 1 Verified Solution 7 Comments 6,091 Views Last Modified: 2012-08-21 Hello, I have a spreadsheet with some code in it, but compile error when i try to launch one of the forms I get the error: Compile Error: Automation Error Unspecified Error The error doesn't go to any specific piece of code to give me any hints as to what the actual problem might be. Then - I view one of the forms I have built in. When i right click on the form and select "View Code" I get the error; Automation Error Unspecified Error I click compile error in OK and it is immediately followed by another dialog box with the error: Property is write only. I really don't know where to start... I have attached the file I am having trouble with. I use the button on the second sheet to open the forms called "Treeview". Thanks in advance for your help. Craig 120514-JDE-ProcessMap-Documentat.xlsm 0 Question by:slobber72 Facebook Twitter LinkedIn Google LVL 39 Active 1 day ago Best Solution byals315 I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations: Go to Solution 7 Comments LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Applications 11 Message Active 1 day ago Accepted Solution by:als3152012-08-21 I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations: http://dutchgemini.wordpress.com/2012/04/17/excel-vba-error-could-not-load-an-object-because-it-is-not-available-on-this-machine/ 0 LVL 44 Overall: Level 44 MS Excel 34 MS Office 13 MS Applications 11 Message Active today Expert Comment by:Martin Liss2012-08-21 It works normally for me. 0 LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Applications 11 Message Active 1 day ago Expert Comment by:als3152012-08-21 @MartinLiss: for me also, but only when I've restored old mscomctl.ocx (6.01.9833) and reregis
or outdated Difficult to follow Other Comments:(Max 1000 chars) Would you like a response? Email is required. Email: KB00686 - Fixing "Automation Error" in Excel after applying MS12-060 Product: PI BatchView / PI DataLink / PI Tag Configurator Version(s): Multiple Platform: Windows Issue If you have already applied the Microsoft patch MS12-060, you may see the error "Automation Error: Unspecified Error" or "System Error &H8000FFF (-2147418113). Catastrophic failure" when starting Microsoft Excel. When closing Excel with PI DataLink enabled, you may also see the error "Compile error in hidden module: modAddin." Solution Typically, these errors can be resolved by searching for and deleting all *.exd files on the machine (including hidden files) as described in KB00804. In some cases, the fix for this problem is to re-register MSCOMCTL.OCX. To do this, follow the steps noted in the Microsoft article "Unspecified Automation Error" after applying MS12-060. Article ID: KB00686 Created: 2012-08-16 Article Type: How-To Last Updated: 2015-02-02 Enabling Operational Intelligence Privacy Legal Copyright Contact Us