Microsoft Visual Basic Compile Error Automation Error Unspecified Error
Contents |
Buffington [MSFT]August 15, 201229 Share 0 0 This article applies toWord, Access, Excel and PowerPoint. MS12-060 is a security update that was released Tuesday, automation error vba August 14, 2012. This update replaced MS12-027. You may now be seeing automation error excel one of the following errors: "Unspecified Automation Error" when running or compiling your Microsoft Office VBA code
Automation Error Vb6
after installing MS12-060; or "Errors were detected while saving ‘filename.xlsm'. Microsoft Office Excel may be able to save the file by removing or repairing some features. To make
Vba Automation Error The Object Has Disconnected From Its Client
the repairs in a new file, click Continue. To cancel saving the file, click Cancel." clicking continue you will see "Document failed to save" or similar error. Update - 9/26/2012. See this blog post for the latest update. Fixit Available There is a fixit available for this problem: Office 2010 w vba automation error unspecified error internet explorer SP1 - http://support.microsoft.com/kb/2597986 Office 2007 w SP2 or SP3 - http://support.microsoft.com/kb/2687441 Office 2003 w SP3 or Office 2003 Web Components w SP3 - http://support.microsoft.com/kb/2687323 Steps to fix the problem manually Alternatively, the manual fix for this problem is to re-register MSCOMCTL.OCX. To do this, follow these steps: 1. Open an administrative-level command prompt. The command prompt MUST be on the administrative level for this to work. Click START, and type RUN in the run command line. On Windows Vista and Windows 7 you will see CMD.EXE appear in the quick searchlist. Right click CMD.EXE and left click Run As Administrator. A black command prompt opens. On Windows XP, there is no built-in run-as-admin, but you can use the run as menu option (or runas command line) to execute an admin command from a Limited User Account. 2. If on a 64-bit machine, type the following: regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX Hit ENTER then type regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX If on a 32-bit machine, type the following: regsvr32.exe /u C:\Windows\System32\MSCOM
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: KB2687441 Causing Compile Error Excel
Excel Vba Automation Error Catastrophic Failure
Add-in Microsoft Office > Excel IT Pro Discussions Question 0 Sign vba automation error exception occurred in to vote --------------------------- Microsoft Visual Basic --------------------------- Compile error: Automation error Unspecified error --------------------------- OK run time error automation error Help --------------------------- Since this update replaces KB2598041 I tried the recommended fix listed to delete the .exd files but this did not help this time. https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/08/15/unspecified-automation-error-after-applying-ms12-060-updated-926/ We had to do this fix in April when it was originally installed. Thursday, August 16, 2012 1:30 PM Reply | Quote Answers 3 Sign in to vote Hi, Please refer to the following steps to check the issue: Click Start -> type in “cmd” in the search lineType in: regsvr32 /u mscomctl.ocxType in: regsvr32 https://social.technet.microsoft.com/Forums/office/en-US/3795aab0-9329-41d9-a820-c166aad4ff19/kb2687441-causing-compile-error-excel-addin?forum=excel mscomctl.ocxJaynet Zhang TechNet Community Support
Marked as answer by Jaynet ZhangMicrosoft contingent staff, Moderator Tuesday, August 21, 2012 2:02 AM Friday, August 17, 2012 9:20 AM Reply | Quote Moderator 0 Sign in to vote On some PC's I alsohad to remove the .exd files (from ...\AppData\Roaming\Microsoft\Forms\) to solve the problem. Only re-registering mscomctl.ocx did not work. Marked as answer by Jaynet ZhangMicrosoft contingent staff, Moderator Tuesday, August 21, 2012 2:02 AM Monday, August 20, 2012 12:03 PM Reply | Quote All replies 0 Sign in to vote This seems to be the line of code: Public batchCollection As Collection Thursday, August 16, 2012 1:42 PM Reply | Quote 0 Sign in to vote MSCOMCTL.OCX specifically is the problem. KB2687441 loads version 6.1.98.34 of this file. I searched on my ssytem and found the same file but version 6.1.95.45 in a system cache. Copied this over the new version, unregistered and reregistered the file and my problems went away. Gofor 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 https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines http://peltiertech.com/unspecified-painfully-frustrating-error/ Experts Exchange > Questions > Excel 2010 VBA - Automation Error - Unspecified Error Want to Advertise Here? Solved Excel 2010 VBA - Automation Error - Unspecified Error Posted on 2012-08-20 automation error MS Applications MS Office MS Excel 1 Verified Solution 7 Comments 6,144 Views Last Modified: 2012-08-21 Hello, I have a spreadsheet with some code in it, but 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 vba automation error 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 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 today 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 today 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 ms
Jon Peltier Peltier Technical Services, Inc., Copyright © 2016. In recent months I have encountered a particularly troublesome error. It occurs in Excel 2003 and 2007 (and perhaps in earlier versions, but I don't recall any such cases). The error is heralded by an unusually unhelpful error message, even my Microsoft's standards: Microsoft Visual Basic - System Error &H80004005 (-2147467259). Unspecified error. Pardon my French, but WTF? To rub salt into the wound, this is followed up with an Out of Memory error: Sometimes these occur once, sometimes twice, when Excel is started, when a workbook with code is opened, or when an add-in is opened. Association with RefEdit Controls Closer examination sheds some light on the problem. It seems to be related to our old friend, the RefEdit control. If a workbook or add-in has a UserForm with a RefEdit, this error may occur. When the error occurs, it may be impossible to view the UserForm in the VB Editor, or if the UserForm can be viewed, any RefEdits have been stripped off the form. UserForms without RefEdit controls can be viewed with no problems. On a computer that experiences the problem, the RefEdit library (refedit.dll) is not available in the references under the VB Editor's Tools menu,and sometimes it turns up as a MISSING reference in this list. The RefEdit library is also not found in the list of Additional Controls which can be added to the VBE's Controls Toolbox. If the RefEdit control had been present on the Controls Toolbox, its place may be taken by a gray square with a tooltip of "Unknown". Interestingly enough, the RefEdit library is present on the machine, in the Microsoft Office program directory. But the library is apparently not accessible. There have been some recent changes in the RefEdit control, I believe on more than one occasion, but I have never documented the changes. There are no outwardly visible differences in the control, but the file size has changed, the file created or modified date has changed, and the file version has changed. History This famous Unspecified Error, its hex code 80004005 burned into many a programmer's retinas, has been around for a long time, in Visual Basic 6 and probably earlier. It has been blamed on many factors, many of which seem like wild guesses, and most of which are irrelevant to our situation here. There are a lot of instances in which this error occurred in projects which dealt with retrieval of data from data controls or databases (Access, Oracle, SQL Server, and others). This error