8002801d Automation Error Library Not
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 02 Oct 2016 22:01:57 GMT by s_hv996 (squid/3.5.20)
One games Xbox 360 games PC
Automation Error Library Not Registered Windows 7
games Windows games Windows phone games Entertainment All run-time error '-2147319779 (8002801d) Entertainment Movies & TV Music Business & Education Business Students &
Automation Error In Vb6 On Windows 7
educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/8002801d-automation-error-library-not-registered/5717123b-4c0b-4a3d-8bb5-7d0fe84e6ac9 Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft https://support.microsoft.com/en-us/kb/963755 Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Forum Visual Basic Programming Visual Basic 6.0 Programming -2147319779 (8002801d) Automation Error - Library Not Registered If this is your first visit, http://forums.codeguru.com/showthread.php?497853-2147319779-(8002801d)-Automation-Error-Library-Not-Registered be sure to check out the FAQ by clicking the link above. http://stackoverflow.com/questions/25029484/vb6-program-fails-opening-excel-2007-with-automation-error-library-not-registere You may have to register or Login before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: -2147319779 (8002801d) Automation Error - Library Not Registered Tweet automation error Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 25th, 2010,11:43 AM #1 DMothes View Profile View Forum Posts Junior Member Join Date May 2010 Posts 2 -2147319779 (8002801d) Automation Error - Library Not Registered I created an input request form database using Access 2003 which automatically automation error library creates an email using VBA to create the email. In the VBA environment, I selected the reference to the Microsoft Outlook 11.0 Object Library. This program works fine on all computers using Windows XP but we recently purchased a laptop with Windows 7 running Office 2003 and on that computer the runtime error -2147319779 (8002901d) Automation error - library not registered occurs. I believe the problem is a DLL file that is missing but have 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 = "L
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 VB6 program fails opening Excel 2007 with Automation Error Library not registered up vote 1 down vote favorite I created this VB6 program on my Windows 7 32bit machine with Office 2010 32bit, which runs fine. Tested it on a Windows 8 64 bit machine with Office 2013 32bit, it works. On one machine with, Windows 7 64 bit and Office 2007(32 bit only) it throws an error during the following piece of code. The actual error message: Run-time Error –2147319779 (8002801d) Automation error, Library not registered VB6 Code: If (excel_app Is Nothing) Then Set excel_app = CreateObject("Excel.Application") Else Set excel_app = GetObject(, "Excel.Application") End If excel_app.Visible = True excel_version = excel_app.Application.Version Set wBook = excel_app.Workbooks.Open(directory_path & "\templates\book1.xlsm") So it is throwing the error when I open book1. It actual does open it and it has a macro run on Workbook_Open(), this runs right through seemly fine. After it finishes and processing of the program returns to the VB6 program it throws the error. Here are the project references: Has anyone come across this and what would be the fix? [EDIT] I am obviously doing something wrong here my error handler is throwing an error. I did try one other thing and that was removed "Set wBook = " and it didn't throw an error. I have placed "Set wBook = " back since then, as I do need it further on in my code. Dim wBook As Workbook Dim excel_app As Object On Error GoTo trialhandler If (excel_app Is Nothing)