Microsoft Visual Basic Compile Error Automation Error
Contents |
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll automation error vba be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums
Automation Error Excel
users FAQ Search related threads Remove From My Forums Asked by: Excel VBA -- Compile Error:Automation Error Microsoft ISV Community Center > Visual Basic
Automation Error Unspecified Error Vba
for Applications (VBA) Question 0 Sign in to vote I wrote an Excel VBA program for my company that has been utilized for about a year with over 350 users, all running Windows XP and Office 2007. A handful
Automation Error Vb6
of users who receive a new laptop (same as mine), have experienced a "Compile Error: Automation Error" when they attempt to run the program. There are no error codes, and the compile error points to a procedure declaration that compiles fine on other PCs: "Public Function KeyFound(strKey As String, SourceCollection As Collection) As Boolean". I have commented out the procude only to get another compile error at a different procedure. I checked for missing references and found none; vba automation error the object has disconnected from its client I have disabled any Add-Ins; I tried to delete all .EXD files; nothing works. One user reinstalled Office and got the program to run, another, needed to have IT rebuild his laptop and got it to work. I need to find the problem so I don't have to keep having users rebuild their laptops. Any help would be greatly appreciated. Thursday, April 26, 2012 3:23 PM Reply | Quote All replies 0 Sign in to vote I think the key is in the rebuild. The original build may not be a full installation and the rebuild is, or something extra that causes the problem is in the original and not the rebuild.Rod Gill The one and only Project VBA Book Rod Gill Project Management
Thursday, April 26, 2012 8:45 PM Reply | Quote 0 Sign in to vote Read this: VBA - Object library invalid or contains references to object definitions that could not be found (pl-PL)Oskar Shon, Office System MVP Press if Helpful; Answer when a problem solved Monday, April 30, 2012 12:35 PM Reply | Quote Answerer 0 Sign in to vote Cebelaw, I am getting exactly the same errors as you described, although it seems to have occurred following a Windows Update (enforced by my system admin, so I cannot undo it). Did you ever solve this problem or find its root cause? Saturday, September 22, 2012 10:11 PBuffington [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, August 14, 2012. This update replaced MS12-027. You may now be seeing vba automation error unspecified error internet explorer one of the following errors: "Unspecified Automation Error" when running or compiling your Microsoft excel vba automation error catastrophic failure Office VBA code after installing MS12-060; or "Errors were detected while saving ‘filename.xlsm'. Microsoft Office Excel may be able to vba automation error exception occurred save the 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 https://social.msdn.microsoft.com/Forums/en-US/72a8a9ce-6a4f-4137-8185-a351a2375e52/excel-vba-compile-errorautomation-error?forum=isvvba 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 or Office 2003 Web Components w SP3 - http://support.microsoft.com/kb/2687323 Steps to fix the problem manually Alternatively, the manual https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/08/15/unspecified-automation-error-after-applying-ms12-060-updated-926/ 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 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
here for a quick overview of the site Help Center Detailed answers to any http://stackoverflow.com/questions/34803843/excel-vba-automation-error-due-to-jan-2016-office-update-probably-caused-by-m 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 http://www.vbaexpress.com/forum/showthread.php?39821-Compile-Error-Automation-Error about 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 automation error Overflow is a community of 6.2 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 vba automation error EDITED ONCE 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
VBA Code & Other Help Excel Help Compile Error: Automation Error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Compile Error: Automation Error Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-15-2011,06:32 AM #1 Hoopsah View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2007 Posts 299 Location Compile Error: Automation Error Hi I recently got an upgraded computer from IT and now cannot get one of my old programs to work. When I open the Excel file everything works as it should, however, when I try to save I get a pop-up stating that Document could not be saved, I click ok, and then every cell I click on is greeted with a pop-up stating Automation Error I have tried on someone elses PC and all was fine I assume I am missing a library or object but I have exhaused google to no avail Any help apprecieted Hoops I am playing all the right notes, but not necessarily in the right order. Eric Morecambe Reply With Quote 11-15-2011,06:46 AM #2 Paul_Hossler View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Apr 2007 Posts 4,170 Location In the VBIDE Tools, References, and see if any are #Missing Paul Reply With Quote 11-15-2011,07:12 AM #3 Hoopsah View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2007 Posts 299 Location I did check the other user and all that had ticked were: Visual Basic for Applications Microsoft Excel 10.0 Object Library OLE Automation Microsoft Office 10.0 Object Library I have the same ticked within my VB I am playing all the right notes, but not necessarily in the right order. Eric Morecambe Reply With Quote 11-15-2011,05:08 PM #4 mdmackillop View Profile View Forum Posts View Blog Entries View Articles AdministratorVP-Knowledge Base VBAX Grand Master Joined May 2004 Location Scotland Posts 12,873 Location With Vista & Win7 you cannot save to the root folder (C Drive) using code. MVP (Excel 2008-2010) "Provide sample data and layout if you want a