Excel Visual Basic Compile Error Automation Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss excel visual basic compile error in hidden module the workings and policies of this site About Us Learn more about excel vba compile error Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Excel Vba Compile Error Variable Not Defined
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each
Excel Vba Compile Error Object Library Invalid
other. Join them; it only takes a minute: Sign up What is causing “Automation 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 excel vba compile error invalid qualifier regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. So I have 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
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 08:42:38 GMT by s_wx1094 (squid/3.5.20)
for 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 https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html 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 http://superuser.com/questions/1016789/compile-error-in-hidden-module-automation Store Headlines Experts Exchange > Questions > Excel 2010 VBA - Automation Error - Unspecified Error Want to Advertise Here? Solved Excel 2010 VBA - Automation Error - Unspecified compile error Error Posted on 2012-08-20 MS Applications MS Office MS Excel 1 Verified Solution 7 Comments 6,124 Views Last Modified: 2012-08-21 Hello, I have a spreadsheet with some code in it, but when i try to launch one of the forms I get the error: Compile Error: Automation Error Unspecified Error The error doesn't go to any specific piece of code excel vba compile to give me any hints as to what the actual problem might be. Then - I view one of the forms I have built in. When i right click on the form and select "View Code" I get the error; Automation Error Unspecified Error I click OK and it is immediately followed by another dialog box with the error: Property is write only. I really don't know where to start... I have attached the file I am having trouble with. I use the button on the second sheet to open the forms called "Treeview". Thanks in advance for your help. Craig 120514-JDE-ProcessMap-Documentat.xlsm 0 Question by:slobber72 Facebook Twitter LinkedIn Google LVL 39 Active today Best Solution byals315 I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations: Go to Solution 7 Comments LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Applications 11 Message Active today Accepted Solution by:als3152012-08-21 I think you have problem with MS s
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 or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Compile error in hidden module Automation up vote 0 down vote favorite I have recently been issued with a mathematical model in an Excel spreadsheet. This involves copious numbers of sheets, with many macros and a boatload of VBA behind the scenes. But the model is rather old and was last known to work on Windows XP, Excel 2003. I am currently using Windows 8.1 and Excel 2013, and it is producing the error message:- Compile error in hidden module: Automation twice on starting up and once on closing down; the model doesn't work either although no further error message is produced. Does anyone know how to fix the problem causing this message to appear? (I suspect the model's failings are related to this.) microsoft-excel windows-xp windows-8.1 share|improve this question asked Dec 22 '15 at 15:40 Brian Hooper 73841329 We have no way of knowing the issue without seeing the VBA. Obviously something in the module Automation is no longer compatible. The failure is likely exiting the routine, meaning nothing else is running. There have been a lot of changes to Excel VBA since 2003. You are going to have to debug it to find where is is failing. –CharlieRB Dec 22 '15 at 15:52 @CharlieRB, so the "Automation" isn't some Microsoft thing, then? I feared as much. Thank you. –Brian Hooper Dec 22 '