Excel 2010 Microsoft Visual Basic For Applications Automation Error
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 automation error vba excel About Us Learn more about Stack Overflow the company Business Learn more about
Automation Error Excel
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss automation error vb6 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 What is causing “Automation vba automation error the object has disconnected from its client error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2 I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. So I have
Visual Basic Automation Error
auto-calc set to manual, and the following code in the worksheet: Private Sub Worksheet_Activate() A_Dates.Calculate End Sub This has worked fine for the last 3 months, day-in and day-out. Yesterday, it stopped working. 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 to no avail. I've also included error handling: On Error Resume Next which doesn't prevent it. I've even gone so far as: Private Sub Worksheet_Activate() On Error GoTo headache Sheets("Dates").Calculate Exit Sub headache: Exit Sub End Sub and it still shows up. I am totally at a loss. Help? 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 12.0 Object Library Microsoft Scripting Runtime Microsoft Forms 2.0 Object Runtime Microsoft HTML Object Library Microsoft Internet Controls Microsoft ActiveX Data Objects 2.8 Library Microsoft ActiveX Data Objects Recordset 2.8 Library vba error-handling excel-2007 share|improve this question edited Sep 4 '12 at 21:43 asked Sep 4 '12 at 20:30
Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites Add-in Collections Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection excel vba automation error catastrophic failure Macro Book Collection Risk Analysis Collection Time Saving Collection Software Download information automation error exception occurred Download purchased software Add-in improvements and upgrades Trial verisions Support Support How to contact us Top support questions
Excel 2013 Automation Error
What to do if add-in tabs or buttons do not appear Money back guarantee Ordering FAQ's Product FAQ's How to open and use our add-ins How to repair Microsoft Excel COM http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate add-ins and why and how to remove How to stop Microsoft Excel From crashing Need more help? Let us connect computers Resources Excel problems solved by our add-Ins Excel and PC tips Excel and Office newsletters Excel and Office user groups Excel and Office training Links to other Excel sites Excel operating problems and solutions Company About Add-ins.com LLC How to contact https://www.add-ins.com/support/automation_error.htm us Policies Affiliate program License agreement View Cart Quantity Discounts Money back guarantee What to do if you get the message "Automation Error" If you get the message "automation error" when you open Excel after installing or when you click on the icon to open the add-in, the problem is caused by a problem with the installation of Microsoft Office. There is not a problem with the add-ins. Re-installing our add-ins does not solve. The problem is often caused by un-installing a trial version of Excel 2007, a missing service pack or an Office patch that was automatically run by Windows. It is sometimes caused by getting Office pre-installed on the PC when you purchase the PC. Please follow the instructions on our page on how to repair Office to solve. Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's Download Information * Ordering Questions * Support Product List * New Products * Free Products * Trial Versions * Products by Others Copyright 2016 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 20:31:54 GMT by s_ac4 (squid/3.5.20)
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Automation Error - Catastrophic Failure Microsoft Office > Excel IT Pro Discussions Question 0 Sign in to vote Hello, I have worked on a file for long time using Excel 2003. I have few macros and custom functions written. I decided to use another computer to do some additional work on this file - mainly new formulas and outline, but no code writing. The file was opened as 2003 and was saved in the same fashion, was not converted to 2007 at any point. I saved it and closed it. I then opened it on my original computer and after opening it gave me "Automation Error - Catastrophic Failure" message without an error number. Right after that it sent me to VBA screen and instead of having my file name under the Project Tree, it has "VBAproject". I click on it and can see my code and my forms, but the worksheets are not label properly plus they have this little blue icon next to them. I tried to open the file again by clicking Disable macros, and no error was given but obviously can't do much with the file. One thing I read around is about sharing and references. This file sharing options were turned off so that's not it. I then realized under VBA-Tools-References that the office 2007 is referencing different files for some of the selections, like Visual Basic For Applications, Microsoft Excel 12.0 Object Library, etc. I copied those files to the proper folders on the 2003 computer but that didn't do the trick. When I click disable macros and go to check the references in the 2003 version everything looks normal. Any ideas? I did quite of work on this file so redoing this is the last resort but I hope I don't have to go that route. Thank y