Automation Error Exception Occurred Excel
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 Learn more about hiring developers excel vba automation error exception occurred or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Microsoft Visual Basic Automation Error Exception Occurred
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 automation error exception occurred project 2010 takes a minute: Sign up Automation Error. Exception Occurred when running a macro up vote 0 down vote favorite I've recently been having issues running macros on one computer running Excel 2010 on Windows 7 Professional. Whenever I try to automation error exception occurred excel 2013 run a macro, I get an indefinite progress bar with a message 'Please wait...' and the workbook grays out slightly in the background. After a period of time, I get the error Automation Error. Exception occurred and the workbook closes. For all intents and purposes, the specific macro doesn't seem to matter, as I've written basic MsgBox Hello World scripts and they throw the same error. What's unique is that I do not get this error if I either (1)
Excel 2010 Automation Error Exception Occurred
run the macro from within the VBE, or (2) have the VBE open in the background. It seems that having the VBE open allows me to run macros. I've done some searching and haven't found any solutions that matched my situation. I'd appreciate any help. excel vba excel-vba excel-2010 share|improve this question asked Apr 21 at 20:13 user3561813 3,3041417 2 This was asked a day or two ago... let me see if I can find it. Edit: see here. –findwindow Apr 21 at 20:15 @findwindow Thanks for the link. While it sounds like some of the symptoms may be the same, I'm not sure that it's the same problem. I'm not calling any userforms, and the error occurs even on the simplest lines of code. Again, thanks for the help. I'll continue researching as well to see if I can't figure it all out. –user3561813 Apr 21 at 20:29 Do you have any personal macros that could be firing? –findwindow Apr 21 at 20:32 @findwindow I don't have any personal macros –user3561813 Apr 21 at 20:48 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post
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 http://stackoverflow.com/questions/36779550/automation-error-exception-occurred-when-running-a-macro 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 Excel 2013 Automation Error Would anyone know why a macro that works without a problem in Excel 2010 now crashes Excel http://www.excelforum.com/showthread.php?t=999513 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 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
Forums Excel Questions Problems running macro VBA Results 1 to 8 of 8 Problems running macro VBAThis is a discussion on Problems running macro VBA within the Excel Questions forums, part of the http://www.mrexcel.com/forum/excel-questions/288260-problems-running-macro-visual-basic-applications.html Question Forums category; I have the following problem: I received an Excel file with https://www.experts-exchange.com/questions/28308782/Excel-crashes-when-running-Macro-with-Automation-Error.html VBA macro. It runs when pressing the macro button. ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 6th, 2007,11:10 AM #1 guido124 New Member Join Date automation error Jul 2005 Posts 36 Problems running macro VBA I have the following problem: I received an Excel file with VBA macro. It runs when pressing the macro button. When I save the file, close it and re-open, it crashes when pressing the macro button. If I then close, re-open and now first save (before running the macro), I can run the macro successfully. The colleague who wrote the macro, automation error exception can run it under all circumstances. With other colleagues, for some it works, for others it doesn't. Does anybody know what could cause this? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 6th, 2007,11:17 AM #2 Jonmo1 MrExcel MVP Join Date Oct 2006 Location Bryan, TX Posts 41,806 1. We'll probably need to see the code to help. 2. Describe "Crashes". What exactly happens? Does it give an error? What error? Do you have a Debug Option when it errors? What line is highlighted... 3. Without knowing the above information, Best guess is a Difference in Excel Versions between you and your coleague(s). Share Share this post on Digg Del.icio.us Technorati Twitter Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious. Life moves pretty fast. If you don't stop and look around once in a while, you could miss it. Ferris Bueller A.K.A. John Hughes, 1986 Reply With Quote Nov 6th, 2007,11:18 AM #3 brian.wethington Board Regular Join Date Jul 2006 Location Irving TX Posts 1,723 Without having seen any code, the line the code err
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 Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Excel crashes when running Macro with Automation Error Want to Advertise Here? Solved Excel crashes when running Macro with Automation Error Posted on 2013-12-03 MS Excel Visual Basic Classic 1 Verified Solution 31 Comments 2,150 Views Last Modified: 2013-12-06 Hi, Excel crashes when I press a button which runs a macro userform1.show OR when I use auto_open. If I go into the vba code and run it line by line, the program works fine. Once excel has crashed and windows recovers the file, I then get an "Automation Error" box pop up asking me to close the application. I am using Excel 2013 on one computer and Excel 2010 on another, the issue happens on both. Part of my code is pasted below - Please let me know if you need the full code to help identify the issue. Sub StartPro() Haulage.Show End Sub Select all Open in new window which calls Private Sub UserForm_Activate() Me.MultiPage2.Value = 0 End Sub Private Sub UserForm_Initialize() TextBox1.Value = Format(Date, "dd/mm/yyyy") Label4.Caption = Format(Sheets("PHCosts").Range("F2").Value, "Currency") Label5.Caption = Format(Sheets("PHCosts").Range("G2").Value, "Currency") Sheets("Haul").Select 'Registration comboboxes With Me.ComboBox1 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox22 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox43 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox64 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox85 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox106 .RowSource = Range("A2", Sheets("Haul").Range("A2").End(xlDown)).Address End With With Me.ComboBox127 .RowSource