Microsoft Visual Basic Error In Excel 2007 Automation Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 15:54:51 GMT by s_wx1206 (squid/3.5.20)
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
Vba Automation Error The Object Has Disconnected From Its Client
Dev centers Samples Retired content We’re sorry. The content you requested has excel vba automation error catastrophic failure been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users microsoft progressbar control FAQ 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 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 0 Sign 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 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 PC (due to 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 Fra
Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites Add-in Collections Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection Software Download information https://www.add-ins.com/support/microsoft-visual-basis-error-400.htm Download purchased software Add-in improvements and upgrades Trial verisions Support Support How to contact us Top support questions What to do if add-in tabs or buttons do not appear Money back guarantee Ordering FAQ's Product FAQ's How to open and use our add-ins How to repair Microsoft Excel COM add-ins and why and how to remove How to stop Microsoft Excel From crashing Need more help? Let us connect computers Resources Excel problems automation error solved by our add-Ins Excel and PC tips Excel and Office newsletters Excel and Office user groups Excel and Office training Links to other Excel sites Excel operating problems and solutions Company About Add-ins.com LLC How to contact us Policies Affiliate program License agreement View Cart Quantity Discounts Money back guarantee Microsoft Visual Basic Error 400 Some user will get a a dialog titled Microsoft Visual Basic and it contains only the vba automation error number 400, like the following dialog: For users of our software, this error is typically caused by having the add-in file for the Spreadsheet Assistant for Excel 2003 installed as in add-in in Excel 2007 or Excel 2010. The cure is to un-install it and install the correct file. Click File or Office Button, Options, Add-ins, GO. Uncheck Spreadsheet Assistant. Click Browse, go to C:\program files (x86)\add-ins and select Spreadsheet Assistant 2007-2013.xla. If you are not using our software and get the above message, it means that your code is referring to something that does not exist or no longer exists. The cure is is to step through your code line by line until you find the offending statement. From it you will hopefully get the clue to solve. It could be referring to a variable that had been previously set to a range and then the workbook closed. Or trying to run a command in a workbook that does not exist (very difficult to do!) The cure for our users of the Spreadsheet Assistant who get a Microsoft Visual Basic 400 dialog is to do the following: Excel 2007: Open, click the round Office button, Excel Options, Add-ins, and Go (with manage excel addins selected) Excel 2010 Open, Click File, Options, Add-ins, and Go (with manage excel addins