Excel 2010 Vba Automation Error Unspecified 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 About automation error vba Us Learn more about Stack Overflow the company Business Learn more about hiring automation error excel developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the
Automation Error Vb6
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 error Unspecified
Vba Automation Error Unspecified Error Internet Explorer
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 auto-calc set to manual, vba automation error the object has disconnected from its client 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 Farfromunique 1311112 If you comment
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 20:48:44 GMT by s_ac4 (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 https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html 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 http://www.pcreview.co.uk/threads/automation-error-unspecified-error.3584242/ Website Testing Store Headlines Experts Exchange > Questions > Excel 2010 VBA - Automation Error - Unspecified Error Want to Advertise Here? Solved Excel 2010 VBA - Automation Error automation error - Unspecified 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 vba automation error specific piece of code 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-0
get multiple instances of this error in a Microsoft Visual Basic error box. It also happens when I open an existing spreadsheet and when I edit the worksheet. There is no error number. Everything seems to work fine, it is just annoying as heck. I have tried a repair, and a repair/reinstall. Neither has worked. I have not uninstalled Office and reinstalled it. Can anyone help? Thanks in advance. ML Purdy, Jul 31, 2008 #1 Advertisements Jim Thomlinson Guest Try removing any addins that you have. Also remove personal.xls from the xlStart folder. Both of those can have code that would run when you open XL and or a spreadsheet. If that solves your problem then we just need to narrow down which one is causing the problem... -- HTH... Jim Thomlinson "ML Purdy" wrote: > When opening Excel, I get multiple instances of this error in a Microsoft > Visual Basic error box. It also happens when I open an existing spreadsheet > and when I edit the worksheet. > > There is no error number. > > Everything seems to work fine, it is just annoying as heck. > > I have tried a repair, and a repair/reinstall. Neither has worked. > > I have not uninstalled Office and reinstalled it. > > Can anyone help? > > Thanks in advance. Jim Thomlinson, Jul 31, 2008 #2 Advertisements Dave Peterson Guest Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ML Purdy wrote: > > When opening Excel, I get multiple instances of this error in a Microsoft > Visual Basic error box. It also happens when I open an existing spreadsheet > and when I edit the worksheet. > > There is no error number. > > Everything seems to work fine, it is just annoying as heck. > > I have tried a repair, and a repair/reinstall. Neither has worked. > > I have not uninstalled Office and reinstalled it. > > Can anyone help? > > Thanks in advance. -- Dave Peterson Dave Peterson, Jul