Automation Error Unspecified Error Excel 2007 Vba
Contents |
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 automation error vba Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation automation error excel Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like automation error vb6 you, helping each other. Join them; it only takes a minute: Sign up What is causing “Automation error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2 I have a worksheet named "Dates" (object name vba automation error the object has disconnected from its client 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 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
Excel Vba Automation Error Exception Occurred
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:30 Farfromunique 1291112 If you comment that line out and manually force a Recalc (using [F9]) do you receive an error? –mwolfe02 Sep 4 '12 at 21:13 No, I do not. And, everything seems to calculate correctly. –Farfromunique Sep 4 '12 at 21:14 Maybe the error has to do with running any VBA, not necessarily the Calculate
Buffington [MSFT]August 15, 201229 0 0 0 This article applies toWord, Access, Excel and PowerPoint. MS12-060 is a security update that was released Tuesday, August 14, 2012. This update replaced MS12-027. You may now be seeing one
Excel Vba Automation Error Catastrophic Failure
of the following errors: "Unspecified Automation Error" when running or compiling your Microsoft Office run time error automation error VBA code after installing MS12-060; or "Errors were detected while saving ‘filename.xlsm'. Microsoft Office Excel may be able to save the run-time error '-2147 automation error vba file by removing or 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" http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate 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 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 https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/08/15/unspecified-automation-error-after-applying-ms12-060-updated-926/ 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\MSCOMCTL.OCX hit ENTER then type regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX Your Office program should work again after doing this. (Updated) 3. NOTE: The following step is done at your own risk. Microsoft doesn't know about any side effects to deleting this registry key. In cases where the re-registration doesn't work and you still get the error, you will need to open the registry editor (START > RUN > REGEDIT) and find andDELETE the following registry key: HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 to HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0OLD We'v
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Automation Error; Unspecified Error To get replies by our experts at nominal http://www.excelforum.com/showthread.php?t=856532 charges, follow this link to buy points and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 3 of 3 Automation Error; Unspecified Error Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad automation error Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-29-2012,10:03 AM #1 jprisco View Profile View Forum Posts Registered User Join Date 08-29-2012 Location Oswego, NY MS-Off Ver Office 2007 Posts 1 Automation Error; Unspecified Error I am havign issues with multiple users on Excel 2007. There may have been a recent update that is causing these vba automation error issues. All of them are getting an error either when opening Excel or when working on VBA: Microsoft Visual Basic --------------------- Automation error Unspecified error One of my users cannot save files either; it throws an error that unfortunately I have not written down. Has anyone seen similar behavior and can point me in the right direction? Register To Reply 08-29-2012,10:30 AM #2 Kyle123 View Profile View Forum Posts Visit Homepage Forum Guru Join Date 03-10-2010 Location Leeds MS-Off Ver 2013 Win7 Posts 5,869 Re: Automation Error; Unspecified Error Give these tips a try: http://www.cpearson.com/excel/StartupErrors.aspx Register To Reply 08-30-2012,12:52 PM #3 GregMiliates View Profile View Forum Posts Registered User Join Date 08-30-2012 Location New Mexico MS-Off Ver Excel 2007 Posts 1 Re: Automation Error; Unspecified Error I ran into this problem, and after spending a couple frustrating hours on it (!), found the cause and the fix. Turns out you need to un-register and re-register the mscomctl.ocx file. Here's some additional info:http://stackoverflow.com/questions/1...aused-by-forms http://social.technet.microsoft.com/...0-c166aad4ff19 Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread I