Automation Error Exception Occurred Excel 2010
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 Learn more about hiring automation error exception occurred excel 2013 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question automation error exception occurred project 2010 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Sporadic Automation Error: Exception Occurred, Possibly Reference Based up vote 0 down vote favorite 1 My team has had this strange error bugging us during development. From time to time when running VBA on an excel tool that my team is building, Excel will crash and the "Microsoft has stopped working" pop-up will appear and when the user selects the 'close the program' option another pop-up stating "Automation Error Exception Occurred" appears. Now here is where it gets weird: It only happens on the machines running 2007, 2010 and 2013 machines never have this issue. Only happens every couple weeks (every 3-5 versions of the tool). These same machines have been running and testing the tool all day every day up until the point it occurs. There is no noticeable difference between the versions that work and those that don't from a code perspective. The have been several instances where a machine will run the VBA code fine and suddenly the error will start occurring. Once, a 2007 machine encounters the error, that file will never work on that machine or any other 2007 machine again. BUT, if given a fresh copy of the same exact file, sometimes the problem will disappear. after some online review, I have tracked the error down to three references being used: OLE Automation, Microsoft Office 12.0 Object Library, Microsoft CDO for Windows 200 Library. If any of these three are disabled in any combination the VBA will start running bug-free. My questions are: What could cause an error that would allow a tool to work a dozen times on a machine (with or without changes being saved) and suddenly stop running and never run again until replaced with a fresh copy? What possible interactions between the three above references could be related to this? vba excel-vba excel-2007 share|improve this question edited May 24 '14 at 3:22 Jamal 56361625 asked May 7 '14 at 19:46 BenW301 70112 1 Are you using any ActiveX controls not provided as standard by the VBA editor toolbox (i.e. Treeview, Listview, etc)? I had a
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Excel 2013 Automation Error To get replies by our experts at nominal 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 7 of 7 Excel 2013 Automation Error Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-25-2014,07:34 PM #1 Bukovnik View Profile View Forum Posts Registered User Join Date 11-06-2013 Location Phoenix, az MS-Off Ver Excel 2010 Posts 24 http://stackoverflow.com/questions/23526974/sporadic-automation-error-exception-occurred-possibly-reference-based Excel 2013 Automation Error Would anyone know why a macro that works without a problem in Excel 2010 now crashes Excel 2013. The error produced says 'Automation Error Exception Occurred'. If I place a stop in the code and hold the F8 key down, the code runs perfectly (Excel 2013) but if I run it, it will crash. The code is copying a worksheet into a new workbook, adding 2 more worksheets, saving then emailing the workbook before http://www.excelforum.com/showthread.php?t=999513 closing. It goes through the routine about 7 times before crashing (sending only 7 email out). It's something to do with the email because I can bypass that code and it runs that part without a problem. Our office just upgraded all the computers to Office 2013 and I've got to get this macro running again. I had to email 100 reports one-by-one today and I didn't like it. I can put code up if anyone thinks it might help. But like I said the code works if I step through it. Thanks Register To Reply 03-25-2014,09:05 PM #2 6StringJazzer View Profile View Forum Posts Visit Homepage Forum Moderator Join Date 01-27-2010 Location Tysons Corner, VA, USA MS-Off Ver 2010, 2013, 2016 Posts 9,298 Re: Excel 2013 Automation Error I do not have the answer. I have seen automation errors before and they can be rather insidious to diagnose. It can be very specific to your configuration. I have moved from 2010 to 2013 and have not experienced what you describe. You might want to check the libraries you have referenced. You may have to re-reference the Outlook library if you are using Outlook to send the email. The worst automation error I had was when I installed Project 2010, which did not automatically uninstall 2007. I had not even considered this for quite a while but when I uninstalled 2007 the
Occurred'. If I place a stop in the code and hold the F8 key down, the code runs perfectly (Excel 2013) but if I run it, it will crash. The code is copying http://excel.bigresource.com/Excel-2013-Automation-Error-Exception-Occurred--ZYAcGU.html a worksheet into a new workbook, adding 2 more worksheets, saving then emailing the workbook before closing. It goes through the routine about 7 times before crashing (sending only 7 email out). It's something to do with the email because I can bypass that code and it runs that part without a problem. Our office just upgraded all the computers to Office 2013 and I've got to get this macro running again. automation error I had to email 100 reports one-by-one today and I didn't like it. View 6 Replies Similar Messages: Obscure Bug In UserForms ListBox Support: "Exception Occurred" Excel 2010 :: Converting Text Into Date Format - Error Occurred VBA Excel Macro Generates (Automation Error) Randomly Using Office 365 Excel 2010 :: Automation Error - Object Disconnected From Its Client Excel 2010 :: Automation Error When Click On Button That Executes Macro Solver automation error exception Fails In XP- An Unexpected Internal Error Occurred Solver: An Expected Internal Error Occurred, Or Available Memory Was Exhausted Excel 2013 :: Error When Sorting Data With INDEX Formula? Excel 2013 :: VBA Error When Upgraded - Cannot Find Project Or Library Excel 2013 :: Copy Method Of Worksheet Class Failed (Runtime Error 1004) Automation Error After Some Iterations? UserForm - Automation Error Automation Error The Debugger Is Marking The Line With N =... Automation Error With Userforms InVBA Code Automation Error: Object Has Disconnected From Its Client Create Checkboxes Out Of Tab Names In Workbook - Getting Automation Error? Automation Error - The Object Invoked Has Disconnected From Its Clients Excel Automation - Timer? Excel Macros Email Automation Excel IE Automation - Read Web Table Excel / Access Report Automation Excel VBA Automation For Internet Explorer To Website Excel Automation On Tax Free Period / Holiday? Combine VBA Scripts To Increase Automation From SAP To Excel To Access "Const StrURI As String" Issue * Now * Automation Error Excel 2013 :: Mail Merging From Excel Database To Outlook List Top Occurred Values Count Number Of Cells Since A Value Has Occurred Find With Exception ADVERTISEMENT Obscure Bug In UserForms ListBox Support: "Exception Occurred" Aug 29, 2004 I'd like to report an obscur