Automation Error Unspecified Error Vba Fix
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 19:11:54 GMT by s_hv902 (squid/3.5.20)
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
Automation Error Excel
MS12-027. You may now be seeing one of the following errors: "Unspecified automation error vb6 Automation Error" when running or compiling your Microsoft Office VBA code after installing MS12-060; or "Errors were detected while vba automation error the object has disconnected from its client saving ‘filename.xlsm'. Microsoft Office Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 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 SP1 - http://support.microsoft.com/kb/2597986 Office 2007 w SP2 or SP3 - http://support.microsoft.com/kb/2687441 Office 2003 w SP3 https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/08/15/unspecified-automation-error-after-applying-ms12-060-updated-926/ 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\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 e
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 https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html Expand Search Submit Close 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 VBA - Automation Error - Unspecified Error Posted on 2012-08-20 MS Applications MS Office MS Excel 1 Verified Solution 7 Comments 6,076 Views Last Modified: 2012-08-21 Hello, I have a spreadsheet automation error 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 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" automation error unspecified 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 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 today Expert Comment by:als31