Automation Error Catastrophic Failure .net
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Automation Error - Catastrophic Failure Microsoft Office > Excel IT Pro Discussions Question 0 Sign in to vote Hello, I have worked on a file for long time using Excel 2003. I have few macros and custom functions written. I decided to use another computer to do some additional work on this file - mainly new formulas and outline, but no code writing. The file was opened as 2003 and was saved in the same fashion, was not converted to 2007 at any point. I saved it and closed it. I then opened it on my original computer and after opening it gave me "Automation Error - Catastrophic Failure" message without an error number. Right after that it sent me to VBA screen and instead of having my file name under the Project Tree, it has "VBAproject". I click on it and can see my code and my forms, but the worksheets are not label properly plus they have this little blue icon next to them. I tried to open the file again by clicking Disable macros, and no error was given but obviously can't do much with the file. One thing I read around is about sharing and references. This file sharing options were turned off so that's not it. I then realized under VBA-Tools-References that the office 2007 is referencing different files for some of the selections, like Visual Basic For Applications, Microsoft Excel 12.0 Object Library, etc. I copied those files to the proper folders on the 2003 computer but that didn't do the trick. When I click disable macros and go to check the references in the 2003 version everything looks normal. Any ideas? I did quite of work on this file s
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 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: Sign up Automation Error / Catastrophic Failure when debugging VSTO project up vote 0 down vote favorite I'm building a document-level VSTO customization for an Excel 2016 workbook, and I'm encountering this error repeatedly in the development process. Basically, Visual Studio 2015 builds the project, Excel loads the workbook, and https://social.technet.microsoft.com/Forums/office/en-US/341479ae-903a-423e-9a51-c3456ae7ad13/automation-error-catastrophic-failure?forum=excel immediately Excel displays an "Automation Error / Catastrophic Failure" message. It kicks me into the VBA editor, but there's no code on the screen to edit. I read in a few places that the error means there is something wrong with the "References" settings in the VBE, but it won't let me open that screen, the option is grayed out. Anything else I try to do just pulls that error up again. The only way out is to stop the process through Visual Studio. If I open http://stackoverflow.com/questions/37243603/automation-error-catastrophic-failure-when-debugging-vsto-project the source workbook directly from the project folder, the same problem occurs, and I have to quit Excel via Task Manager. This problem has been coming and going over the past 24 hours; last night and this morning it wasn't happening for some reason, so I was having no issues running and testing my project, but now the problem is back. If anyone has an idea of what could be causing this problem (bearing in mind it must be something that has not been constant over the past day), I'm all ears. Even just an idea of what to look for would be helpful, as I don't even know what this error means or what kinds of things to look for. This is my first VSTO project and I've been pretty excited by what I was able to accomplish when this error wasn't coming up every time, so I'd like to eliminate the problem permanently. Edit: I should point out that the reason I included VSTO in the question title is that this workbook was totally fine before I started the VSTO project. But I saw this error when I tried to run the VSTO project for the first time, yesterday. vb.net excel vba vsto share|improve this question edited May 15 at 21:06 asked May 15 at 20:58 Philip F. 12 Please see how to provide a Minimal, Complete, and Verifiable example - if you can't then your question is probably too broad for this site. –Macro Man May 15 at 21:20 So, the workbo
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 http://stackoverflow.com/questions/1487406/vb6-automation-error-on-calls-to-net-3-5-assemblies-after-the-first-calls Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads 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: Sign up VB6 Automation Error on Calls to .NET automation error 3.5 Assemblies After the First Calls up vote 0 down vote favorite Some of the sources I've checked already: http://www.experts-exchange.com/Programming/Languages/.NET/Visual%5FBasic.NET/Q%5F23359339.html http://mygreenpaste.blogspot.com/2006/03/net-framework-20-configuration-tool.html http://support.microsoft.com/kb/186063 I'm busy developing .NET modules that will hook into our existing VB6 code. I've created a test VB6 project from which to launch the new code which comprises of a form with a button, and on the button's click event is Dim launcher As automation error catastrophic New VB6InteropLaunchPad.launcher launcher.FormTypeEnum = FormTypeEnum_MySpecificForm launcher.launchAppropriateForm It is successful the first time I click the button. However, if I click the button again, I get the following error: Run-time error '-2146233079 (80131509)': Automation Error Subsequent calls to the .NET code fail with the same error message unless I close and restart the IDE. If I compile the VB6 project to an EXE the same thing happens. I have to close the EXE and run it again to be able to access the .NET code. I've tried the suggestion on http://support.microsoft.com/kb/186063 and did the following: Option Explicit ' http://support.microsoft.com/kb/186063 Const FORMAT_MESSAGE_FROM_SYSTEM = &H1000 Private Declare Function FormatMessage Lib "kernel32" Alias _ "FormatMessageA" (ByVal dwFlags As Long, lpSource As Long, _ ByVal dwMessageId As Long, ByVal dwLanguageId As Long, _ ByVal lpBuffer As String, ByVal nSize As Long, Arguments As Any) _ As Long Private Function MessageText(lCode As Long) As String Dim sRtrnCode As String Dim lRet As Long sRtrnCode = Space$(256) lRet = FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM, 0&, lCode, 0&, _ sRtrnCode, 256&, 0&) If lRet > 0 Then MessageText = Left(sRtrnCode, lRet) Else MessageText = "Error not found." End If End Function On Error GoTo errHandler Dim launcher As New VB6InteropLaun