Automation Error Library Not Registered Outlook
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 18:49:41 GMT by s_hv1002 (squid/3.5.20)
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From automation error library not registered windows 7 My Forums Answered by: Automation Error - Library Not automation error library not registered 2147319779 Registered Scripting > The Official Scripting Guys Forum! Question 0 Sign in to 8002801d automation error - library not registered vote I created an input request form database using Access 2003 which automatically creates an email using VBA to create the email. This http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/8002801d-automation-error-library-not-registered/5717123b-4c0b-4a3d-8bb5-7d0fe84e6ac9 program works fine on all computers using Windows XP but we recently purchased a computer with Windows 7 and on that computer the runtime error Automation error - library not registered occurs. I believe the problem is a DLL file that is missing but have https://social.technet.microsoft.com/Forums/scriptcenter/en-US/a8350b39-75d8-47d8-ba78-13d585832ff2/automation-error-library-not-registered?forum=ITCG no idea which DLL file. Does anyone have any suggestions on how to fix this problem? I have included the code and where the error occurs for reference: Private Sub cmdSubmitRequest() Dim olApp As Outlook.Application Dim olNS As Outlook.NameSpace Dim olfolder As Outlook.MAPIFolder Dim olMailItem As Outlook.MailItem Dim varBodyText As Variant Dim strName As String Dim strDepartment As String Dim strChargeNumber As String Dim strRequiredDate As String Dim strRequestDate As String Dim strAddtionalInfo As String Dim strWorkLocation As String Dim strProductType As String strName = "Last Name: " strDepartment = "Department: " strChargeNumber = "Charge Number: " strRequiredDate = "Date Wanted: " strRequestDate = "Date Written: " strWorkLocation = "Location: " strProductType = "Product Type: " strAdditionalInfo = "Description of Work: " Set olApp = CreateObject("Outlook.Application") Runtime Error Occurs At This Line o
Tech Support Guy, we highly recommend that you visit our Guide for New Members. Solved Library not Registered error - VBA Outlook Discussion in 'Business Applications' started by draceplace, May 12, 2016. Thread Status: Not open https://forums.techguy.org/threads/library-not-registered-error-vba-outlook.1171195/ for further replies. Advertisement draceplace Thread Starter Joined: Jun 8, 2001 Messages: 2,195 Been running this email generation VBA code for years (currently Access 2013) and this week it went south on me. But another person in my https://www.experts-exchange.com/questions/22532916/Automation-Error-Library-not-registered.html group runs the process just fine from his PC. The error: Run-time error '-2147319779 (8002801d)': Automation error Library not registered. OS=Win7 (Office 365 thing going) running Access 2013 and Outlook 2013 on corporate LAN. The offending line of automation error code is: Set MyOutlook = New Outlook.Application This doesn't work either: Set MyOutlook = GetObject(, "Outlook.Application.15") Lots there on Google but nothing giving me confidence to edit the registry yet. Hoping you guys helping on all the Excel notification request here have seen this. Thanks for reading my post draceplace, May 12, 2016 #1 Sponsor Rollin_Again Joined: Sep 4, 2003 Messages: 4,863 What is showing when you display your references in the VB editor? You library not registered might be able to just re-register a DLL or something using the rgsvr32 command. Rollin_Again, May 12, 2016 #2 DataBase Joined: Jan 15, 2004 Messages: 664 Can you try this Dim MyOutlook as object Set MyOutlook = CreateObject("Outlook.Application") have you checked your reference to ensure nothing is missing? DataBase, May 12, 2016 #3 draceplace Thread Starter Joined: Jun 8, 2001 Messages: 2,195 I'm not inclined to think changing the code is going to fix the problem since this runs on two other users PC. I'm thinking a registry issue, This is in the Code Dim MyOutlook As Outlook.Application Rollin my References look like the attached: References look same on working PCs as well Attached Files: OutlookReference1.PNG File size: 7.6 KB Views: 5 draceplace, May 12, 2016 #4 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,066 You have Outlook 2015 registered, but your system description says Outlook 2013. "OS=Win7 (Office 365 thing going) running Access 2013 and Outlook 2013 on corporate LAN. So which is it? and what have the working computers got? Have you recently had a big MS update like me? OBP, May 12, 2016 #5 draceplace Thread Starter Joined: Jun 8, 2001 Messages: 2,195 I am appreciating all the help! OBP, Outlook version 15.0 is actually Outlook 2013 (outlook 2010 is 14.xx, etc) Working computers are the same. We are
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Automation Error Library not registered Want to Advertise Here? Solved Automation Error Library not registered Posted on 2007-04-25 MS Office MS Access MS Excel 6 Verified Solutions 14 Comments 7,919 Views Last Modified: 2008-02-07 I'm actually very scared to ask this question because I suspect the answer will require hours of work for me. I have an Access application that comes up with the message "Automation Error Library not registered" when I it gets to the command Set xlApp = CreateObject("Excel.Application") I have MS Office 2003 loaded on my PC and all of MS Office 2007 except Excel 2007 (because it fouls up on a download from Lotus Notes that I need to do every week). I am running the application that fails on MS Access 2003. I have reference to Microsoft Excel 11.0 Object Library checked. Does anyone have any suggestions as to what I may need to do to fix the problem? 0 Question by:Rob4077 Facebook Twitter LinkedIn Google LVL 119 Active 1 day ago Best Solution byRey Obrero try late binding dim xlApp as object set xlApp=Createobject('Excel.application") did you uninstall Excel 2007? Go to Solution 14 Comments LVL 85 Overall: Level 85 MS Excel 85 MS Office 25 MS Access 16 Message Assisted Solution by:Rory Archibald2007-04-25 If you have a reference to the Excel library, have you tried: Set xlApp = New Excel.Application Regards, Rory 0 LVL 119 Overall: Level 119 MS Access 119 MS Excel 18 MS Office 16 Message Active 1 day ago Accepted Solution by:Rey Obrero2007-04-25 try late binding dim xlApp as object set xlApp=Createobject('Excel.application") did you uninstall Excel 2007? 0 LVL 59 Overall: Level 59 MS Excel 39 MS Office 24 MS Access 13 Message Expert Comment by:Chris Bottomley2007-04-25 I suspect tis easy!!! in excel macro edi