Microsoft Visual Basic For Applications Compile Error Automation Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 18:14:26 GMT by s_wx1126 (squid/3.5.20)
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 vba automation error catastrophic failure Excel Add-in Microsoft Office > Excel IT Pro Discussions Question 0
Vba Automation Error Unspecified Error Internet Explorer
Sign in to vote --------------------------- Microsoft Visual Basic --------------------------- Compile error: Automation error Unspecified error ---------------------------
Automation Error Exception Occurred
OK Help --------------------------- Since this update replaces KB2598041 I tried the recommended fix listed to delete the .exd files but this did not help http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/excel-2007-compile-error-automation-error-on/c4e0edaf-9a51-4fd6-8aa1-2bce1dd2b1da this time. 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 https://social.technet.microsoft.com/Forums/office/en-US/3795aab0-9329-41d9-a820-c166aad4ff19/kb2687441-causing-compile-error-excel-addin?forum=excel /u mscomctl.ocxType in: regsvr32 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 thhere 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 Learn more http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3-0-caused-by-forms about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users http://www.tek-tips.com/viewthread.cfm?qid=1681635 Badges Ask Question x Dismiss 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 Excel/VBA Automation Errors due to Office Service Pack 3.0 caused by Forms up vote 6 down vote favorite 4 After installing all latest windows updates my Excel VBA automation error code is showing an automation error at the very start of the first module. It contains some forms as well as numerous modules of VBA code. However, when removing the forms (and associated code) everything is fine. The same thing happened about a year ago after some other windows updates. Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different. What is going on and how vba automation error can I get the forms to work? All the code is unchanged and has survived all previous windows/office updates. Running Windows 7 (same happening on Vista machine) and Office 2007. windows excel vba ms-office windows-update share|improve this question asked Aug 15 '12 at 14:38 Rob 4343716 add a comment| 11 Answers 11 active oldest votes up vote 16 down vote accepted I used to see this a lot with Visual Basic and Crystal Reports; either due to a bad deployment or DLL Hell. So, my guess is that it's not the code but perhaps some 3rd party controls (OCXs, DLLs) you're using. Check your References (In VBA IDE, click Tools and References) and to see where each DLL is pointing. See if any of the dates on the libraries are different than a working machine and you may find the culprit. Edit The OP found the problem by following the steps above. The fix for this particular issue is to unregister mscomctl.ocx: regsvr32 /u mscomctl.ocx Then register it: regsvr32 mscomctl.ocx share|improve this answer edited Aug 16 '12 at 9:57 answered Aug 15 '12 at 14:52 ray 4,74942849 Not straight forward to compare, but only key difference I found is "Microsoft Windows Common Controls 6.0 (SP6) MSCOMCTL.OCX which is dated 6/6/12 on the updated (and not working) machine and 4/11/11 on an "old" one. Not using any 3rd part
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. VBA Visual Basic for Applications (Microsoft) Forum at Tek-Tips HomeForumsProgrammersLanguagesVBA Visual Basic for Applications (Microsoft) Forum Excel VBA -- Compile Error: Automation Error thread707-1681635 Forum Search FAQs Links MVPs Excel VBA -- Compile Error: Automation Error Excel VBA -- Compile Error: Automation Error cebalaw (Programmer) (OP) 26 Apr 12 11:34 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 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 procedure only to get another compile error at a different procedure. I checked for missing references and found none; 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. RE: Excel VBA -- Compile Error: Automation Error SkipVought (Programmer) 26 Apr 12 11:43 hi,It happens, from time to time, when I get my laptop refreshed (replaced), that some dll or a driver or some