Microsoft Visual Basic Runtime Error Automation Error
Contents |
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev runtime error automation error vba centers Samples Retired content We’re sorry. The content you requested has been
Run Time Error 462 The Remote Server Machine
removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ run time error 462 excel vba Search related threads Remove From My Forums Answered by: Excel 2010 VB Run-time Error '-2146232576 (80131700)' Automation Error on CreateObject("System.Collections.ArrayList") ??? Microsoft Office for Developers > Excel for Developers Question 0 Sign runtime error automation error the object invoked has disconnected from its clients in to vote Hi All, Has anyone seen this nasty compiler/configuration bug before when trying to use an Excel 2010 Visual Basic macro command like: Set myPriceArray = CreateObject("System.Collections.ArrayList") Stops and throws a "Run-time Error '-2146232576 (80131700)' Automation Error" I just did a fresh install of Windows 8.1 Pro Full 64-bit with Excel 2010 32-bit on my desktop PC (due to
Runtime Error 80131700
Microsoft discontinuing XP support)and any macros I have that use CreateObject("System.Collections.ArrayList") now crash. The full macro is listed below and works fine on other machines like {Windows 8.1 Full, Excel 2010 32-bit} or {Windows XP, Excel 2010}, or {Windows XP, Excel 2007}. I tried: uninstalling/reinstalling Excel 2010 32-bit, checking for updates then repair Excel 2010 32-bit, uninstalling/reinstalling Excel 2010 64-bit, checking forupdates then repair Excel 2010. Still nothing - crashes every time. Can anyone help? Thanks! Andy *************** Here's the Code That Stops the Macro Option Explicit Private Sub CommandButton1_Click() Dim myPriceArray As Object '****** '* Excel crashes on this next command here with a '* "Run-time Error '-2146232576 (80131700)' Automation Error on the Set myPriceArray = CreateObject("System.Collections.ArrayList") '****** Set myPriceArray = CreateObject("System.Collections.ArrayList") myPriceArray.Add (105) myPriceArray.Add (106) myPriceArray.Add (107) myPriceArray.Add (108) myPriceArray.Clear Set myPriceArray = Nothing MsgBox ("Arraylist Finished") End Sub Friday, May 30, 2014 8:17 PM Reply | Quote Answers 2 Sign in to vote Hi Jim, Thanks for the suggestion - Success! This one actually worked for me. I downloaded Microsoft .NET Framework 2.0 SP2 (which automatically also instal
360 games PC games the remote server machine does not exist or is unavailable 'createobject' Windows games Windows phone games Entertainment All Entertainment microsoft visual basic runtime error 2146232576 Movies & TV Music Business & Education Business Students & educators
Automation Error Excel
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://social.msdn.microsoft.com/Forums/en-US/9bfcd001-5168-4cff-b2ba-6b8e8d465138/excel-2010-vb-runtime-error-2146232576-80131700-automation-error-on?forum=exceldev Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/178510 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate the company Business Learn more about hiring developers or posting ads with us Stack http://support.sas.com/kb/44379 Overflow Questions Jobs Documentation Tags Users Badges Ask 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 What is causing “Automation error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2 I time error 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, and the following code in the worksheet: Private Sub Worksheet_Activate() A_Dates.Calculate End Sub This has worked runtime error automation 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 that line out and manually force a Recalc (using [F9]) do you receive an error? –mwolfe02 Sep 4 '12 at 21:13 No, I do not. And, everything seems to calculate correctly. –Farf
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