Edit The OP found the problem by following the steps above. any suggestions / help? Turns out you need to un-register and re-register the mscomctl.ocx file. Opening Excel on its own, does not give an error. http://objectdevcorp.com/automation-error/automation-error-visual-basic-excel.html
Range("B1").Activate vCellValue = Range("B1").Value Range("B1").ClearContents Range("B1").Value = vCellValue (where B1 is in the row you want to insert a row next to) share|improve this answer answered Feb 23 '15 at 11:52 Rounding a number up to the nearest multiple of a power of 2 Simple geometry. Word to describe object that can be physically passed through Is there one word that describes the attribute of being either disposable or reusable? Reference Trappable Errors Core Visual Basic Language Errors Core Visual Basic Language Errors 440 Automation error 440 Automation error 440 Automation error 3 Return without GoSub 5 Invalid procedure call or http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000
Your cache administrator is webmaster. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. share|improve this answer answered Aug 27 '12 at 1:30 Tom Pydeski 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Can guns be rendered unusable by changing the atmosphere?
Should I be concerned about "security"? Why are static password requirements used so frequently? Click START, and type RUN in the run command line. Automation Error Access If cookies are made with enough sugar, will they just be chewy caramel?
Please see also: http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/08/15/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx share|improve this answer answered Aug 20 '12 at 9:30 hrattink 1 add a comment| up vote 0 down vote son of a gun...I re-registered C:\Windows\System32\MSCOMCTL.OCX and everything Comment out the second "Set NewBook" line of code... the interesting thing is that sometimes it will make it through 5 cycles of code before breaking, sometimes only 2. Browse other questions tagged excel-vba automation runtime-error or ask your own question.
Do your SaveAs after copying the sheets. Automation Error Excel 2013 Does the wifi hump affect aerodynamics or efficiency? I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. Real valued polynomial has real coefficients Make loop more efficient Is every non stationary series convertible to a stationary series through differencing 5 Favorite Letters Could the atmosphere be depleted and
It works fine for between 74 and 86 loops and then suddently the CreateObject("InternetExplorer.Application") fails. http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3-0-caused-by-forms Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Automation Error; Unspecified Error To get Visual Basic Automation Error share|improve this answer answered Dec 9 '13 at 0:32 StymiedforAwhile 111 Weird, when I added this statement to my macro it worked, but it had some side effects, so Automation Error Excel Additional Information I have the following references, and use all of them in various macros in this workbook: Visual Basic for Applications Microsoft Excel 12.0 Object Library OLE Automation Microsoft Office
So, my guess is that it's not the code but perhaps some 3rd party controls (OCXs, DLLs) you're using. navigate here When I attempted to open up the forms in my addin, I got a different error and I could not open the forms. It still broke in the same spot. –William Jun 25 '13 at 18:05 add a comment| 7 Answers 7 active oldest votes up vote 6 down vote accepted I have had In my case, registering the new mscomctl.ocx with regsvr32 was enough to fix the issue. Vba Automation Error The Object Has Disconnected From Its Client
Would this be considered as plagiarism? Can guns be rendered unusable by changing the atmosphere? Join them; it only takes a minute: Sign up What is causing “Automation error Unspecified error” on Worksheet_Activate? Check This Out I also put a "timer" in at one point to make sure that the excel sheets were not walking over each other.
Oddly, one system had no issues despite the update - the newest system. As you say unregistering and registering works perfectly. –Rob Aug 16 '12 at 8:08 add a comment| up vote 5 down vote Same issue here, problem completely solved after registering mscomctl.ocx! Add the below statement just before copying to destination. Excel Vba Automation Error Catastrophic Failure The only consistency is that it always breaks in the same place fromBook.Sheets("Report").Copy Before:=newBook.Sheets("Sheet1") I have option Explicit at the top of the module, and I have checked to make sure
I cannibalized them from other systems. Purpose of pins on side edge of QFN package How do you combine the elements in Sheldon's T-shirt? All of them are getting an error either when opening Excel or when working on VBA: Microsoft Visual Basic --------------------- Automation error Unspecified error One of my users cannot save files http://objectdevcorp.com/automation-error/automation-error-440.html The "Addins" tab won't show up on my Ribbon, so I can't get access to the features I need for excel automation ... ...
Also, you might want to check if these application extensions are present in windows\sysWOW64 or windows\system32 for 32-bit system FM20.DLL (Modified Date: 7/7/2011, version 12.0.6604.1000, 1.13MB) FM20ENU.DLL (Modified Date: 10/24/2008, version My boss asks me to stop writing small functions and do everything in the same loop Could the atmosphere be depleted and put in to bottles? share|improve this answer answered Sep 7 '12 at 14:42 Sebastian Fernandez 211 add a comment| up vote 2 down vote Check out http://support.microsoft.com/kb/2687441 for an update that may fix this problem share|improve this answer answered Aug 15 '12 at 16:00 Corey 1 add a comment| up vote 0 down vote I had the same problem.
share|improve this answer answered Aug 16 '12 at 0:06 Marc 1 add a comment| up vote 0 down vote Un- and registering the MSCOMCTL.ocx did the trick for me: Open an Le Châtelier's Principle and heat Higher up doesn't carry around their security badge and asks others to let them in. Does that generate an error? –mwolfe02 Sep 4 '12 at 21:17 Yes, it does generate the same error. A black command prompt opens.
What is going on and how can I get the forms to work? I've also included error handling: On Error Resume Next which doesn't prevent it. share|improve this answer answered Aug 15 '12 at 21:31 zukunt 1 add a comment| up vote 0 down vote Had the same issue on all of our terminal servers after one Please follow the instructions on our page on how to repair Office to solve.
It now throws this error on the declaration line: Microsoft Visual Basic Automation error Unspecified error [OK] [Help] I have tried changing how I reference the sheet, using: Sheets("Dates").Calculate and ActiveSheet.Calculate