Microsoft Visual Basic Automation Error Unspecified Error In Word 2007
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 vba automation error unspecified error internet explorer released Tuesday, August 14, 2012. This update replaced MS12-027. You may automation error excel now be seeing one of the following errors: "Unspecified Automation Error" when running or compiling your automation error vba Microsoft Office VBA code 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
Automation Error Vb6
repairing some features. To make 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 vba automation error the object has disconnected from its client for this problem: Office 2010 w 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 ENT
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 microsoft progressbar control About Us Learn more about Stack Overflow the company Business Learn more about
Runtime Error Automation Error Unspecified Error
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Excel Vba Automation Error Catastrophic Failure
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is causing “Automation https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/08/15/unspecified-automation-error-after-applying-ms12-060-updated-926/ error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2 I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. So I have http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate auto-calc set to manual, and the following code in the worksheet: Private Sub Worksheet_Activate() A_Dates.Calculate End Sub This has worked fine for the last 3 months, day-in and day-out. Yesterday, it stopped working. It now throws this error on the declaration line: Microsoft Visual Basic Automation error Unspecified error [OK] [Help] I have tried changing how I reference the sheet, using: Sheets("Dates").Calculate and ActiveSheet.Calculate to no avail. I've also included error handling: On Error Resume Next which doesn't prevent it. I've even gone so far as: Private Sub Worksheet_Activate() On Error GoTo headache Sheets("Dates").Calculate Exit Sub headache: Exit Sub End Sub and it still shows up. I am totally at a loss. Help? Additional Information I have the following references, and use all of them in various macros in this workbook: Visual Basic for Applications Microsoft Excel 12.0 Object Library OLE Automation Microsoft Office 12.0 Object Library Microsoft Scripting Runtime Microsoft Forms 2.0 Object Runtime Microsoft HTML Object Library Microsoft Internet Controls Microsoft ActiveX Data Objects 2.8 Library Microsoft ActiveX Data Objects Recordset 2.8 Library vba error-handling excel-2007 share|improve this question edited Sep 4 '12 at 21:43 asked Sep 4 '12 at 20:3
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. https://community.oracle.com/thread/2431162 You can not post a blank message. Please type your message and http://www-01.ibm.com/support/docview.wss?uid=swg21608271 try again. More discussions in BI Publisher All PlacesBusiness IntelligenceBusiness Intelligence FoundationBI Publisher This discussion is archived 3 Replies Latest reply on Dec 4, 2012 6:40 PM by tmrabet - oracle Automation Error in MS Word user1086916 Aug 20, 2012 3:52 PM OK, This isn't a question but I wanted to automation error get in the forum to help other people. Recently, we had an Issue with MS Word reporting 'Automation Error' when trying to use the BI Publisher plugin. This was strange, since: - It occoured on every machine we had MS Word installed on. - Even machines that were previously working stopped. The solution to the issue (was eventually found here): http://blogs.technet.com/b/wordonenotesupport/archive/2012/08/16/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx Interestingly the automation error unspecified date of the post is quite recent (16.08.2012). And just fyi, the solution is to unregister and re-register the C:\Windows\System32\MSCOMCTL.OCX file - this is in the link but I wanted to record it just in case the link gets deleted or something. So I just wanted this posted to the forum in case it will help other people. 4568Views Tags: none (add) This content has been marked as final. Show 3 replies 1. Re: Automation Error in MS Word MWshobz Aug 21, 2012 11:53 PM (in response to user1086916) Many thanks for the solution. I spent several hours to realize that you have a ready solution for this problem. Rest, please note this command has to be Run as an administrator to get the MSCOMCTL.OCX re-registered. Thanks, Shob Like Show 0 Likes(0) Actions 2. Re: Automation Error in MS Word Pawan S-Oracle Oct 11, 2012 12:25 PM (in response to MWshobz) 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\MSCOMCTL.OCX hit ENTER then type regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX Your
Error Unspecified Error Technote (troubleshooting) Problem(Abstract) After receiving a Microsoft update(s), users trying to access TM1 Perspectives see the following error message: Symptom Microsoft Visual Basic Automation Error Unspecified Error Cause The following Microsoft updates have been released August 2012. See bulletin below for all updates released; http://technet.microsoft.com/en-us/security/bulletin/ms12-aug This issue is specific to this Microsoft Office security Update KB2687441 Environment Excel 2007 on Windows Resolving the problem *** Excel must be closed before performing these steps*** Unregister and re-register the mscomctl.ocx file. NOTE: The following must be performed on the machine where problem is occurring when logged into the machine as a user in the local Administrators group. Open a command prompt window. When applicable (Windows Vista, Windows 7, Windows Server 2008 R2), you must use the "Run as Administrator" mode/option when opening the command prompt window Run the appropriate commands indicated below. For 64 bit machines: regsvr32 /u C:\Windows\SysWOW64\mscomctl.ocx regsvr32 C:\Windows\SysWOW64\mscomctl.ocx For 32 bit machines: regsvr32 /u C:\Windows\System32\mscomctl.ocx regsvr32 C:\Windows\System32\mscomctl.ocx Once the file has successfully re-registered, start Perspectives to confirm whether this has resolved the problem. For additional information including for other Operating system and Excel versions, please see the following Technote: http://www-01.ibm.com/support/docview.wss?uid=swg21438688 OR Upgrade to Office 2010 Cross reference information Segment Product Component Platform Version Edition Business Analytics Cognos Express Cognos Xcelerator Perspectives Windows 2003 server, Windows 10.1, 10.2.1 Document information More support for: Cognos TM1 TM1 Perspectives Software version: 9.5.2, 10.1.0 Operating system(s): Windows Software edition: All Editions Reference #: 1608271 Modified date: 02 January 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility