Automation Error 80131700
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 "run-time error '-2146232576 (80131700)' automation error Community Magazine Forums Blogs Channel 9 Documentation APIs and reference runtime error 2146232576 in excel Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be runtime error 2146232576(80131700) auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Excel
Excel Run Time Error '2146232576
2010 VB Run-time Error '-2146232576 (80131700)' Automation Error on CreateObject("System.Collections.ArrayList") ??? Microsoft Office for Developers > Excel for Developers Question 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 = runtime error 80131700 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 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("S
Automation Error Cause Microsoft Word 2003 is out of date. Solution Apply all updates to http://support.informationmapping.com/hc/en-us/articles/201661471-Error-Run-time-error-2146232576-80131700- Word 2003. Was this article helpful? 0 out of 0 found this helpful Facebook Twitter LinkedIn Google+ Have more questions? Submit a request Comments Related articles Error: Run-time error -2147024770 (8007007e) Error: Run-Time Error 2147024894 (80070002) Questions? Feedback? powered by Olark live chat software Powered by Zendesk
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 http://superuser.com/questions/1073915/excel-vba-run-time-automation-error About Us Learn more about Stack Overflow the company Business Learn more about http://www.biopdf.com/guide/trouble_shoot_microsoft_office_2003.php hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer time error The best answers are voted up and rise to the top Excel VBA - Run Time Automation Error up vote 0 down vote favorite I have this below VBA code (pretty common found on this site itself as well as other places on the net to find SHA hash in VBA) that works just fine in Excel 2013 on Windows 7 32. However the same code runtime error 2146232576 when run in Excel 2003 SP3 on Windows 7 32 gives Run Time Automation Error at line Set asc1 = CreateObject("System.Text.UTF8Encoding") I am unclear why it is failing in Excel 2003. Assuming it has something to do with dot net framework I re-installed dot Net 4.0 while 3.5.1 is already part of Windows 7 and Feature already enabled. There is very similar post on this site here but even it does not have a solution. What else should I troubleshoot further? Could this be something to do with missing or corrupt components / libraries or anything related? Thanks. Public Function SHA1(str1) Dim asc1 As Object Dim enc1 As Object Dim bytes, outstr, pos Set asc1 = CreateObject("System.Text.UTF8Encoding") Set enc1 = CreateObject("System.Security.Cryptography.SHA1CryptoServiceProvider") bytes = asc1.GetBytes_4(str1) bytes = enc1.ComputeHash_2((bytes)) outstr = "" For pos = 1 To LenB(bytes) outstr = outstr & LCase(Right("0" & Hex(AscB(MidB(bytes, pos, 1))), 2)) Next SHA1 = outstr Set asc1 = Nothing Set enc1 = Nothing End Function Private Sub CommandButton1_Click() Dim txt txt = TextBox1.Text TextBox2.Text = SHA1(txt) End Sub microsoft-excel vba runtime-error share|improve this question edited May 8 at 20:07 asked May 6 at 15:06 pat2015 706311 In the V
Awards & Press PDF Writer - Trouble Shoot Microsoft Office 2003 Error -2146232576 (80131700) and Error -2147024894 (80070002) Since the program started to use the Microsoft.NET Framework there has been some problems when using the COM API from VBA (Visual Basic for Applications) running in Microsoft Office 2003. This is not a problem for later versions of Microsoft Office. Symptoms A runtime error -2146232576 (80131700) or -2147024894 (80070002) is shown when specific functions are called in the COM API. This usually happens when you have a macro that uses the printer. Reason There is an error in Microsoft Office 2003 in connection with Microsoft.NET Framework 2.0. Resolution Microsoft has released a fix for this error. More information and the fix is available at the link below. http://support.microsoft.com/kb/908002/en-us Even though the fix describes Add-ins and smart tags it also applies to this problem. If you just install the downloaded fix it will look for a Visual Studio 2005 installation. This search will probably fail, since you most likely do not have that installed. I suggest that you do the following to apply the fix. Download the fix from the link above. Unpack the downloaded executable file using a program such as WinZip or 7zip. Run the following command line from the folder where you unpacked the files. office2003-kb907417sfxcab-ENU.exe /quit The /quiet will make the fix run unattended. If you follow the instructions above then the problem should be fixed. Keywords: Microsoft Office 2003, VBA, Macros, -2146232576, 0x80131700, -2147024894, 0x80070002, Microsoft Excel 2003, Microsoft Word 2003 © Copyright 2016 bioPDF. All rights reserved | Privacy Policy | PAD files