Access Automation Error The System Cannot Find The File Specified
Contents |
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 automation error the system cannot find the file specified vba or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x ms access automation error. the system cannot find the file specified 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 regasm codebase takes a minute: Sign up Excel .NET COM - Automation error. The system cannot find the file specified up vote 13 down vote favorite 1 I have a .NET 2.0 COM object that's used by VBA in Excel. It works automation error in vba fine on my dev machine, but when trying to use it on a clean VM workstation I get this error: Automation error. The system cannot find the file specified. The dll is registered with "regasm /tlb /codebase mycom.dll" and not put in the GAC. I don't have administration rights on the VM box Any ideas? .net excel com automation share|improve this question asked May 19 '09 at 9:18 ingt 91124 add a comment| 4 Answers 4 active oldest votes up
Regasm Tlb
vote 11 down vote You need to either invoke regasm with the full path to the assembly as the codebase parameter value or put the assembly into some location which is always on the path for searching libraries. Otherwise it will not be found when the client tries to instantiate the COM object. share|improve this answer answered May 19 '09 at 12:09 sharptooth 109k49315704 I did try using regasm on the full path of the assembly which is located in c:\temp, but still the same error –ingt May 19 '09 at 14:07 1 Then I guess your best bet is to start ProcessMonitor - technet.microsoft.com/ru-ru/sysinternals/bb896645.aspx - and look what file exactly is not found. It could be some dependent assembly you're not at all aware of. Once you know for sure it will be much easier to resolve. –sharptooth May 20 '09 at 4:51 sharptooth, thank you very much for this answer. It saved my hide today! –Matthew Talbert Sep 23 '09 at 8:50 THank you this helped alot –David Jan 29 '14 at 14:59 add a comment| up vote 6 down vote On windows 7, 64 bit and a .NET 4.0 framework dll (32 bit) that I want to be usable as a COM object for a Microsoft Excel 2010 VBA application, here is what worked for me. Copy the dll to c:\windows\syswow64 In a cmd shell, run C:\Windows\Microsoft.NET\Framework\v4.0. 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 centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related run time error '-2147024894' threads Remove From My Forums Answered by: error -2147024894 (80070002) Automation Error Archived Forums V > Visual Basic Interop and Upgrade Question 0 Sign in dependency walker to vote hi guys, this too is in relation to this thread.i'm having problems running the vb6 app, and the error occurs when i make the form show. i've followed the instructions from the help file and still the problem http://stackoverflow.com/questions/881750/excel-net-com-automation-error-the-system-cannot-find-the-file-specified arises everytime.here's another weird thing, when i added the interop form to an existing vb6 application, it was ok when run inside the ide. when i compiled this to an .exe file, the error happened. i also tried creating fresh vb6 app and it worked, so any ideas on this issue? thanks.dave. Wednesday, August 29, 2007 3:09 AM Answers 0 Sign in to vote Hi Dave, When you ran it as an .exe file did you have your .NET Dll in https://social.msdn.microsoft.com/Forums/en-US/7c5c16d7-4029-4b6f-9a29-55a1c27718b5/error-2147024894-80070002-automation-error?forum=vbinterop the same directory? On a target machine you need to run regasm (with /codebase if you want a relative path). If you have a dependency on stdole.dll, do you have that in the GAC? (If you don't have it referenced in your .NET project then don't worry about this one). Hope that helps, let me know if you're still having issues with it. Jonathan Friday, August 31, 2007 9:33 PM Moderator All replies 0 Sign in to vote Hi Dave, When you ran it as an .exe file did you have your .NET Dll in the same directory? On a target machine you need to run regasm (with /codebase if you want a relative path). If you have a dependency on stdole.dll, do you have that in the GAC? (If you don't have it referenced in your .NET project then don't worry about this one). Hope that helps, let me know if you're still having issues with it. Jonathan Friday, August 31, 2007 9:33 PM Moderator 0 Sign in to vote hi jonathan, i had a fun time trying to figure out the problem, and yes i even tried your solution before. something must've been wrong with either my vs2005 or vb6 installations, because at one last desperation attempt, i reinstalled everying and it worked. thanks for the advice.dave. Saturday, September 01, 2007 2:55 PM 0 Sign in to vote hello Jonathan... It's urgent... I need ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Advanced ASP.NET/Enterprise Services Integration/automation error, The system cannot find the file specified automation error, The http://forums.asp.net/t/1073809.aspx?automation+error+The+system+cannot+find+the+file+specified system cannot find the file specified RSS 2 replies Last post Feb 20, 2007 02:47 AM by prasant.swain ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email https://community.microstrategy.com/t5/Miscellaneous/TN34917-quot-Automation-error-The-system-cannot-find-the-file/ta-p/185454 Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply prasant.swai... Member 21 Points 10 Posts automation error, The system cannot find the file specified Feb automation error 10, 2007 03:11 AM|prasant.swain|LINK in my .net application i am using a COM file (that is written in vb 6) . this function internally call another dll and reading the globla.asa file using ASPTypeLibrary .. and when i usethe function in my application it is giving me this error automation error The system cannot find the the system cannot file specified. :-2147024894 .. Please if anyone have simillar kind of problem then please give me it's solution.. Thanks.. Prasant Swain Reply SGWellens All-Star 124309 Points 10172 Posts Moderator Re: automation error, The system cannot find the file specified Feb 10, 2007 04:29 PM|SGWellens|LINK With depends.exe, you can look at any executable file and see the list of file it needs to run. http://www.dependencywalker.com/ Steve Wellens My blog Reply prasant.swai... Member 21 Points 10 Posts Re: automation error, The system cannot find the file specified Feb 20, 2007 02:47 AM|prasant.swain|LINK Thankyou SG Wellens.. actually i find the problem. that is due to the missing of a registry entry.. And again thank you for providing such a important tool.. Prasant Swain ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neudesic, LLC. | © 2016 Microsoft. All rights reserved. Privacy Statement| Terms of Use| Contact Us| Advertise With Us| CMS by Umbraco| Hosted on Microsoft Azure Feedback on ASP.NET| File Bugs| Support Lifecycle General Discussions View all Getting Started with the Community Community News Get Connected Business Strategy & Best Practices Suggestions for this Community Technical Discussions View all Announcements Visualization Gallery Tech Corner Idea Exchange Platform (Installation & Deployment) Object Development Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets (Data Sources & Gateways) MicroStrategy Software Development Kit (SDK) Security (Usher) Performance Events View all Events Blog Symposia 2016 Symposia 2015 Education World 2016 Discussions World 2015 Discussions World 2015 Track Sessions & Customer Presentations Community Menu Register · Sign In · Help Miscellaneous MicroStrategy > Miscellaneous > TN34917: "Automation error The system cannot find the file specified" error message appears when launching MicroStrateg... CommunityCategoryKnowledge BaseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. TN34917: "Automation error The system cannot find the file specified" error message appears when launching MicroStrategy Desktop 9.0.2 Started 12-14-2010 by fish Modified 12-14-2010 by fish Article Options Article History Subscribe to RSS Feed Mark as New Mark as Read Bookmark Subscribe Email to a Friend Printer Friendly Page Report Content Labels: Installation 0 Likes SYMPTOM: When the user launches MicroStrategy Desktop 9.0.2, the error below occurs and Desktop cannot be opened: By using Health Center Desktop Component Registration check, the user may see the error below: Sample Code/Error Component Registration": Error running assess: processAssemblyDlls error, couldn't read reg file C:\Program Files\Common Files\MicroStrategy\MICROSTRATEGY.DESKTOP.SYSTEM.reg (The system cannot find the file specified) CAUSE: This issue is caused by a faulty installation. When the user performs the installation through MICROSTRATEGY.exe,in some cases, the installation finisheswithout the error but the installation in incomplete. This issue has also been noticed to be a machine specific problem. ACTION: Please perform a repair installation by following steps below: Copy the installation package to a local drive. Go to the unzipped installation folder and go to "Installations" sub folder. Use setup.exe to run the repair instalRegasm Unregister