Error Loading Dll Vba Excel 2007
Contents |
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Error in loading DLL To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our error in loading dll access Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread error in loading dll excel 2013 Results 1 to 13 of 13 Error in loading DLL Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread runtime error 48 error in loading dll Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-27-2009,10:51 AM #1 costadina View Profile View Forum Posts Registered User Join Date error in loading dll excel mac 11-14-2008 Location Tampa MS-Off Ver Professional Plus 2007 Posts 30 Error in loading DLL Over the weekend I did some edits to an Excel file on my home computer. This morning I did some edits to the file on my work computer. When I try to access the VBA code, I get the message "Error in loading DLL", which is error 48. I am really lost on this. Help! Last edited by costadina;
Error In Loading Dll Vb6
04-27-2009 at 01:08 PM. Register To Reply 04-27-2009,10:58 AM #2 excel_1982 View Profile View Forum Posts Registered User Join Date 04-14-2009 Location London MS-Off Ver Excel 2003 Posts 54 Re: Error in loading DLL Go into tools menu in the VBA environment and look in reference to see if anything dll is missing. If it is then it will say MISSING. Register To Reply 04-27-2009,11:18 AM #3 costadina View Profile View Forum Posts Registered User Join Date 11-14-2008 Location Tampa MS-Off Ver Professional Plus 2007 Posts 30 Re: Error in loading DLL You are right. I went there and a box is check that says "MISSING: Ref Edit Control" Now what should I do? Register To Reply 04-27-2009,11:39 AM #4 excel_1982 View Profile View Forum Posts Registered User Join Date 04-14-2009 Location London MS-Off Ver Excel 2003 Posts 54 Re: Error in loading DLL In the VB editor, select Tools, References, and unclick the refedit control reference. It is not needed. It is a bug in VBA that appeared about six months ago with one of Microsoft's hot fixes as far as I can tell. It gets introduced when one adds a refedit to a userform. Some installations can handle it, some can not. Register To Reply 04-27-2009,11:56 AM #5 costadina View Profile View Forum P
360 games PC games
Error In Loading Dll Microsoft Dao 3.6 Object Library
Windows games Windows phone games Entertainment All Entertainment error in loading dll excel mac 2011 solver Movies & TV Music Business & Education Business Students & educators missing microsoft outlook 15.0 object library Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.excelforum.com/excel-programming-vba-macros/681338-error-in-loading-dll.html 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 Lumia All https://support.microsoft.com/en-us/kb/2019235 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
msg when trying to set an Excel.Worksheet object 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 http://www.vbforums.com/showthread.php?521558-RESOLVED-quot-Error-in-loading-DLL-quot-msg-when-trying-to-set-an-Excel-Worksheet-object proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: [RESOLVED] "Error in loading DLL" msg when trying to set an Excel.Worksheet object Tweet Thread http://www.accessrepairnrecovery.com/blog/how-to-solve-error-48-error-in-loading-dll Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 5th, 2008,07:43 PM #1 DavidY View Profile View Forum Posts Thread Starter New Member Join Date Mar 2008 Posts loading dll 7 [RESOLVED] "Error in loading DLL" msg when trying to set an Excel.Worksheet object I'm using VB6 SP6 and am working on an old project that used to work just fine. After digging it out of the archives and loading the project onto an XP machine it is now running into problems. In the code I am trying to set an Excel.Worksheet object variable to the sheet object of an Excel.Workbook. Here's an example of the source code... Dim error in loading objSht2 As Excel.Worksheet Set objSht2 = objWkb.Worksheets(2) The above error message gets generated upon execution of the second line where I attempt to set the worksheet object. I am using OfficeXP and reference the "Microsoft Excel 10.0 Object Library" in the VB project. I know this is kind of obscure but does anyone have any ideas where I can start looking to try to track this error down? Thanks! Reply With Quote May 5th, 2008,10:23 PM #2 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 21,913 Re: "Error in loading DLL" msg when trying to set an Excel.Worksheet object have you previously set objwkb to the workbook that contains the sheet? does that workbook have 2 (or more) sheets? post some more of your code if you still need help i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part come back and mark your original post as resolved if your problem is fixed pete Reply With Quote May 6th, 2008,01:5
This error has the following causes and solutions: The file isn't DLL-executable. If the file is a source-text file, it must be compiled and linked to DLL executable form. The file isn't a Microsoft Windows DLL. Obtain the Microsoft Windows DLL equivalent of the file. The file is an early Microsoft Windows DLL that is incompatible with Microsoft Windows protect mode. Obtain an updated version of the DLL. The DLL references another DLL that isn't present. Obtain the referenced DLL and make it available to the other DLL. The DLL or one of the referenced DLLs isn't in a directory specified by your path. Move the DLL to a referenced directory or place its current directory on the path. Symptoms This addresses an issue that may arise when specific Microsoft updates released are missing from its database. Or When trying to run wizards in Microsoft Office Access, like Import Wizards, the Query Wizard, the Report Wizard, and Control Wizards, you may receive one of the following errors: "Error in loading dll" "Object library not registered" Error 48 occurs when opening Maintenance Management At the time of starting the program you generally this error occurs: Error: 48 Description: Error in loading DLL Cause When one or more of several Microsoft security updates for Microsoft Office have not been applied or installed or updated then you may get this error. Microsoft security bulletin MS12-060 describes this type of error. According to the version of Microsoft Office you are using, updates must be installed. You may get this error even if any of the following registry keys do not exist. ACEDAO.DLL -2007, 2010, 2013 MSI INSTALLS (64-bit Windows, 32-bit Office): Key: HKEY_CLASSES_ROOT\ TypeLib\{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}\c.0\0\win32 String: (Default) Value: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL (64-bit Windows, 64-bit Office) Key: HKEY_CLASSES_ROOT\ TypeLib\{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}\c.0\0\win64 St