Automation Error Microsoft Visual Basic
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 11:45:55 GMT by s_hv997 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Automation Error Excel
workings and policies of this site About Us Learn more about Stack
Automation Error Vba
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs vba automation error the object has disconnected from its client 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 other. Join them; http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 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 regularly have workbooks http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate 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.0 Object Runtime Microsoft HTML Object Library Microsof
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 http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3-0-caused-by-forms with us Stack Overflow 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 other. Join them; it only takes a minute: https://www.caddit.net/forum/viewtopic.php?t=581 Sign up Excel/VBA Automation Errors due to Office Service Pack 3.0 caused by Forms up vote 6 down vote favorite 4 After installing all latest windows updates my Excel VBA code is showing an automation error at the very start of the automation error first module. It contains some forms as well as numerous modules of VBA code. However, when removing the forms (and associated code) everything is fine. The same thing happened about a year ago after some other windows updates. Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different. What is going on and how can I get the forms to work? All the code is unchanged and has survived all previous windows/office microsoft visual basic updates. Running Windows 7 (same happening on Vista machine) and Office 2007. windows excel vba ms-office windows-update share|improve this question asked Aug 15 '12 at 14:38 Rob 4343716 add a comment| 11 Answers 11 active oldest votes up vote 16 down vote accepted I used to see this a lot with Visual Basic and Crystal Reports; either due to a bad deployment or DLL Hell. So, my guess is that it's not the code but perhaps some 3rd party controls (OCXs, DLLs) you're using. Check your References (In VBA IDE, click Tools and References) and to see where each DLL is pointing. See if any of the dates on the libraries are different than a working machine and you may find the culprit. Edit The OP found the problem by following the steps above. The fix for this particular issue is to unregister mscomctl.ocx: regsvr32 /u mscomctl.ocx Then register it: regsvr32 mscomctl.ocx share|improve this answer edited Aug 16 '12 at 9:57 answered Aug 15 '12 at 14:52 ray 4,68942748 Not straight forward to compare, but only key difference I found is "Microsoft Windows Common Controls 6.0 (SP6) MSCOMCTL.OCX which is dated 6/6/12 on the updated (and not working) machine and 4/11/11 on an "old" one. Not using any 3rd party controls and all worked fine until windows updates ran. –Rob Aug 15 '12 at 15:11 @Rob I would think comparing dates to files would be pretty straight forward, but what evs. The Mscom
up Advanced search Last 24h posts Last 7 days posts Login Hang around Register Join the club MENU Register FAQ The team Advanced search Unanswered posts Active topics Topic TitleTopic description It is currently Sat Oct 01, 2016 6:43 pm Microsoft Visual Basic error Excel 2007 Geomagic Design 3D CAD modelling and Mecsoft Visual Mill CNC software - local Australia technical support. Moderators:caddit, Senseineo Search 1 post 1 post Reply Microsoft Visual Basic error Excel 2007 #1982 by darren Good Fri Mar 01, 2013 1:55 pm I've tried to install the Excel addin ... but I get an error dialog box titled "Microsoft Visual Basic" with the message "Automation Error" inside it. I've tried to find answers online (and here) but haven't found anything that's helped. The "Addins" tab won't show up on my Ribbon, so I can't get access to the features I need for excel automation ... ... any suggestions / help? thank you. edit: Never mind ... finally got success by manually applying fix found here: http://blogs.technet.com/b/the_microsof ... 2-060.aspx Username darren Good Posts 1 Joined Fri Mar 01, 2013 1:18 pm Reply 1 post Page 1 of 1 1 post Return to “Geomagic Design Australia Support” Recent Topics Twitter Favorites Home Gallery Members Chat Delete all board cookies About Us Welcome to Ausstralia/New Zealand's CADDIT CAD software forum. CAD CAM Forum for support and discussion regarding AutoCAD, progeCAD IntelliCAD, Geomagic Freeform, Mathcad, CNC software. This forum offers free support for progeCAD by qualified technical staff. Thank you for visiting. CADDIT.net The CADDIT.net team -All times are UTC- × ×