Automation Error The Specified Module Cannot Be Found Vb6
Contents |
could not be found. If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To automation error the specified module cannot be found microstrategy start viewing messages, select the forum that you want to visit from the selection below. run-time error '-2147024770 (8007007e) Results 1 to 8 of 8 Thread: [RESOLVED] The specified module could not be found. Tweet Thread Tools Show Printable Version Subscribe to
The Specified Module Could Not Be Found
this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 1st, 2012,06:49 AM #1 yasrab View Profile View Forum Posts Thread Starter Lively Member Join Date Nov 2011 Posts 74 [RESOLVED] The specified module could not be found. After the installation the application in win 7 it gives me error whenever i execute a report. Runtime Error Automation Error The specified module could not be found. any suggestion. Reply With Quote Feb 1st, 2012,06:53 AM #2 Hack View Profile View Forum Posts Super Moderator Join Date Aug 2001 Location Searching for mendhak Posts 58,335 Re: The specified module could not be found. Have you verified whether or not the specified module is actually there? Please use [Code]your code goes in here[/Code] tags when posting code. When you have received an answer to your question, please mark it as resolved using the Thread Tools menu. Before posting your question, did you look here? Got a question on Linux? Visit our Linux sister site. I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section. Creating A Wizard In VB.NET Paging A Recordset What is wrong with using On Error Resume Next Good Article: Language Enhancements In Visual Basic 2010 Upgrading VB6 Code To VB.NET Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked Reply With Quote Feb 1st, 2012,07:00 AM #3 yasrab View Profile View Forum Posts Thread Starter Lively Member Join Date Nov 2011 Posts 74 Re: The specified module could not be found. how to verify Reply With Quote Feb 1st, 2012,07:02 AM #4 Hack View Profile View Forum Posts Super Moderator Join Date Aug 2001 Location Searching for mendhak Posts 58,335 Re: The specified module could not be found. What module can't it find? Please use [Code]your code goes in here[/Code] tags when posting code. When you have received an answer to your question, please mark it as resolved using the Thread Tools menu. Before posting your question, did you look here? Got a question on Linux? Visit our Li
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 http://www.vbforums.com/showthread.php?671279-RESOLVED-The-specified-module-could-not-be-found a minute: Sign up ADO Error: Automation error - The specified module could not be found up vote 0 down vote favorite My VB6 application which runs successfully on many machines is producing the above error on just 1 users machine. Machine has Vista SP1 which means the MDAC installer will not work since MDAC 2.8 is already included. Code that leads http://stackoverflow.com/questions/817808/ado-error-automation-error-the-specified-module-could-not-be-found up to the error: 'Temp file to users temp directory: FileName = C:\DOCUME~1\nmiller\LOCALS~1\Temp\TmpPrint.mdb Dim catADO As New ADOX.Catalog catADO.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName Error happens on the .Create line. Any help getting this user going would be greatly appreciated! vb6 ado share|improve this question asked May 3 '09 at 19:35 KerryF 43127 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Is there a permission problem with the file? Perhaps on Vista, you need to grant permission on the file. We know that Vista has much tighter security, including file and folder access. share|improve this answer answered May 3 '09 at 19:42 DOK 24.8k64483 Not that I could see. I logged in with CoPilot and was able to create/edit files in his temp directory with no problems. –KerryF May 3 '09 at 20:19 The permission has to be granted to the app user, which is probably different from your own login. –DOK May 3 '09 at 20:31 How can I test this then? The program is setup to run as administrator.
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://stackoverflow.com/questions/32561620/automation-error-on-vb6-the-specified-module-cannot-be-found-2147024770 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 https://bytes.com/topic/access/answers/796551-ms-access-vba-automation-error 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 on the specified VB6 - “The specified module cannot be found” - 2147024770 up vote 0 down vote favorite I have a VB6 program that uses Excel application to populate the data. The program works on my machine but when I run this on server I am getting automation error: When I rerun the executable in the server again for the second time it works fine. Both the the specified module machines have Excel 2003 and Excel 2010. Error occurs in this line: Set xlApp = CreateObject("Excel.Application") excel vb6 excel-2010 share|improve this question edited Sep 14 '15 at 21:05 pnuts 33.7k63569 asked Sep 14 '15 at 9:40 jeyaganesh 44331740 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Strange. but you can try creating the object twice... On Error Resume Next Set xlApp = CreateObject("Excel.Application") On Error Goto 0 If xlApp is Nothing Then Set xlApp = CreateObject("Excel.Application") End If share|improve this answer answered Dec 2 '15 at 18:33 Ota Milink 384 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged excel vb6 excel-2010 or ask your own question. asked 1 year ago viewed 272 times active 10 months ago Related 0VB6 WIA Module-Automation Error0VB6 “Provider cannot be found.”0Excel Automation Performance o
Post your question and get tips & solutions from a community of 418,436 IT Pros & Developers. It's quick & easy. MS Access VBA "Automation Error" 100+ P: 119 billelev I have the following vba code that returns the "date modified" field from a file, specified in filepath: Expand|Select|Wrap|Line Numbers FunctionGetFileModifiedDate(filepathAsString)AsDate Dimfs,f Setfs=CreateObject("Scripting.FileSystemObject") Setf=fs.GetFile(filepath) GetFileModifiedDate=f.datelastmodified EndFunction On one machine it runs without any problems, but on another I encounter the following error message: Expand|Select|Wrap|Line Numbers Run-timeerror(8007007e) Automationerror Thespecifiedmodulecouldnotbefound. Does anyone know how to fix this? Thanks, May 19 '08 #1 Post Reply Share this Question 9 Replies Expert 5K+ P: 8,394 ADezii I have the following vba code that returns the "date modified" field from a file, specified in filepath: Expand|Select|Wrap|Line Numbers FunctionGetFileModifiedDate(filepathAsString)AsDate Dimfs,f Setfs=CreateObject("Scripting.FileSystemObject") Setf=fs.GetFile(filepath) GetFileModifiedDate=f.datelastmodified EndFunction On one machine it runs without any problems, but on another I encounter the following error message: Expand|Select|Wrap|Line Numbers Run-timeerror(8007007e) Automationerror Thespecifiedmodulecouldnotbefound. Does anyone know how to fix this? Thanks, Set a Reference to the Microsoft Scripting Runtime Library. Rename your Function to: Expand|Select|Wrap|Line Numbers GetFileModifiedDate_2 Modify the Function code to: Expand|Select|Wrap|Line Numbers FunctionGetFileModifiedDate_2(filepathAsString)AsDate DimfsAsFileSystemObject DimfAsFile Setfs=CreateObject("Scripting.FileSystemObject") Setf=fs.GetFile(filepath) GetFileModifiedDate_2=f.DateLastModified EndFunction Let me know how you make out. May 20 '08 #2 reply 100+ P: 119 billelev Thanks for your reply. I tried what you suggested but with no success. Given that the original code worked on one machine, but not the other. Would this not imply that the issue is with the machine, rather than the code? May 20 '08 #3 reply Expert 5K+ P: 8,394 ADezii Thanks for your reply. I tried what you suggested but with no success. Given that the original code worked on one machine, but not the other. Would this not imply that the issue is with the machine, rather than the code? Given that the original code worked on one machine, but not the other. Woul