Microsoft Vb Automation Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 17:53:17 GMT by s_wx1011 (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 workings and policies of runtime error 440 automation error this site About Us Learn more about Stack Overflow the company Business
Automation Error Excel 2013
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask vba automation error unspecified error internet explorer Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 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 open that have too many calculations in the for me to http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate 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 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
Error Unspecified Error Technote (troubleshooting) Problem(Abstract) After receiving a Microsoft update(s), users trying http://www-01.ibm.com/support/docview.wss?uid=swg21608271 to access TM1 Perspectives see the following error message: Symptom Microsoft Visual Basic Automation Error Unspecified Error Cause The following Microsoft updates have been released http://support.sas.com/kb/44379 August 2012. See bulletin below for all updates released; http://technet.microsoft.com/en-us/security/bulletin/ms12-aug This issue is specific to this Microsoft Office security Update KB2687441 Environment Excel 2007 on Windows automation error Resolving the problem *** Excel must be closed before performing these steps*** Unregister and re-register the mscomctl.ocx file. NOTE: The following must be performed on the machine where problem is occurring when logged into the machine as a user in the local Administrators group. Open a command prompt window. When applicable (Windows vba automation error Vista, Windows 7, Windows Server 2008 R2), you must use the "Run as Administrator" mode/option when opening the command prompt window Run the appropriate commands indicated below. For 64 bit machines: regsvr32 /u C:\Windows\SysWOW64\mscomctl.ocx regsvr32 C:\Windows\SysWOW64\mscomctl.ocx For 32 bit machines: regsvr32 /u C:\Windows\System32\mscomctl.ocx regsvr32 C:\Windows\System32\mscomctl.ocx Once the file has successfully re-registered, start Perspectives to confirm whether this has resolved the problem. For additional information including for other Operating system and Excel versions, please see the following Technote: http://www-01.ibm.com/support/docview.wss?uid=swg21438688 OR Upgrade to Office 2010 Cross reference information Segment Product Component Platform Version Edition Business Analytics Cognos Express Cognos Xcelerator Perspectives Windows 2003 server, Windows 10.1, 10.2.1 Document information More support for: Cognos TM1 TM1 Perspectives Software version: 9.5.2, 10.1.0 Operating system(s): Windows Software edition: All Editions Reference #: 1608271 Modified date: 02 January 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification SAS Global Academic Program SAS OnDemand For Academics USERS GROUPS Advanced Search support.sas.com Knowledge Base Support Training & Books Store Support Communities Knowledge Base Products & Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation Notes Search Problem Notes Focus Areas Problem Note 44379: "Run-time error '-2146233086 (80131502)': Automation error" or "Out of memory" when hierarchy.ShowMemberSelectionDialog submitted You might encounter errors if you submit the SASĀ® Financial Management Add-In API for Microsoft Excel's 'ShowMemberSelectionDialog' call. Specifically, this call might result in errors similar to the following if the D74002 hot fix has been applied to your system: Microsoft Visual Basic for Applications Run-time error '-2146233086 (80131502)': Automation error or Microsoft Visual Basic for Applications Out of memory The AMO log might also show: FMHierarchy: Members Property error. Invalid item: Null. Returning Null. For a user who has been assigned the role