Excel 2003 Compile Error Cannot Find Project Or Library
Contents |
360 games PC games compile error cannot find project or library excel 2010 Windows games Windows phone games Entertainment All Entertainment
Compile Error Cannot Find Project Or Library Excel 2013
Movies & TV Music Business & Education Business Students & educators can't find project or library excel 2007 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Can't Find Project Or Library Vb6
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 can't find project or library excel 2016 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Excel Can't Find Project Or Library Crash
and policies of this site About Us Learn more about Stack Overflow
Missing Microsoft Office 16.0 Object Library
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation compile error can't find project or library access 2007 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 https://support.microsoft.com/en-us/kb/840926 only takes a minute: Sign up “Can't find Project or Library” for standard VBA functions up vote 36 down vote favorite 11 So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or Library" on standard functions such as date, format, hex, mid, etc. Some research indicates that if I prefix these http://stackoverflow.com/questions/507191/cant-find-project-or-library-for-standard-vba-functions functions with "VBA." as in "VBA.Date" then it'll work fine. Webpages suggest it has to do with my project references on my system, whereas they must be ok on the developer's system. I'm going to be dealing with this for some time from others, and will be distributing these applications to many others, so I need to understand what's wrong with my excel setup that I need to fix, or what needs to be changed in the xls file so that it'll run on a variety of systems. I'd like to avoid making everyone use "VBA." as an explicit reference, but if there's no ideal solution I suppose that's what we'll have to do. How do I make "VBA." implicit in my project properties/references/etc? vba excel-vba namespaces reference share|improve this question edited Jun 29 '12 at 17:57 JimmyPena 5,97932844 asked Feb 3 '09 at 14:05 Adam Davis 59.1k43211303 are you developing in one version of excel and distributing to users using a different version? –Russ Cam Feb 3 '09 at 14:13 That may be
How do I resolve the error "Compile Error: Can't find project or library?" How do I resolve the error "Compile Error: Can't find project or library?"Article:KB0012541 Published:2012-03-16 Last modified:2016-09-23 How do I resolve the error "Compile Error: Can't find project or library?" Liberty Information Services and the IT HelpDesk are aware of an issue where, https://liberty.service-now.com/kb_view_customer.do?sysparm_article=KB0012541 when using a Microsoft Access or Excel document that integrates buttons or functions that need Visual Basic for Applications (VBA) or Macros to perform their duty, some users may encounter the http://www.excelforum.com/showthread.php?t=921149 following error message: "Compile Error: Can't find project or library." What causes this error? This error message usually is caused by the user's Microsoft Access or Excel program having a reference find project to a type or object library that is missing, rendering the program not able to use Visual Basic or Macro based buttons and functions properly. How can this issue be solved? Please follow these steps to resolve the issue: Open the Microsoft Access or Excel file that is giving you the error message. Make sure the Excel sheet or Data sheet that has find project or the buttons or functions in question is selected. Simultaneously press the ALT and F11 keys on your keyboard to switch to the Visual Basic Editor in a new window (as seen below). In the new Visual Basic Editor window, click on the Tools menu at the top of the screen, and then click References... A References dialogue box will display on the screen. A missing type or object library is indicated by "MISSING:" followed by the name of the missing type or object library (an example is MISSING: Microsoft Excel 10.0 Object Library, as seen below). If there is a check mark in the check box next to the missing type or object library, then un-check the check box. Click OK. Exit the Visual Basic Editor. Save the original Access or Excel file. Try using the buttons or functions in question that previously didn't work and they should now work normally. For further information, please consult: https://support.microsoft.com/en-us/kb/282331FeedbackPlease type feedback before submittingYour feedback has been submitted, thank youPlease submit descriptive feedback after flagging an article, or it will not be modifiedSubmitPermalink: Was this helpful?Thank youYesNoRate this article
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] Excel VBA Error: "Can't find project or library" To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 5 of 5 Excel VBA Error: "Can't find project or library" Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-07-2013,04:36 PM #1 dash11 View Profile View Forum Posts Registered User Join Date 04-08-2011 Location London MS-Off Ver Excel 2007 Posts 58 Excel VBA Error: "Can't find project or library" I created a vba macro that worked last month but without changing anything, I think, it now is giving me an error at the "Set objFSO". It stops there and says "Can't find project or library". Please help!! Sub RateUpdateCopyandPasteLoop() Dim DDir As String Dim DFormat As String Dim i As Long Dim PDFFileName As String Dim Filename As String Dim ActualFilename As String Dim strPath As String ActualFilename = ActiveSheet.Range("B16") DDir = "W:\Derivatives\Swap Documents\Swap Reset Notices (PDF Files)" strPath = "W:\Derivatives\Swap Documents\Swap Reset Notices (Excel Files)" Set objFSO = CreateObject("Scripting.FileSystemObject") Const ForWriting = 2 Set objFolder = objFSO.GetFolder(strPath) Application.ScreenUpdating = False For Each objFile In objFolder.Files If objFSO.GetExtensionName(objFile.Path) = "xls" Then Set objWorkbook = Workbooks.Open(objFile.Path) ' Takes the updated 1 Month Libor figures and pastes values into Data sheet Workbooks.Open Filename:="W:\Derivatives\Swap Documents\1 Month Libor Settings.xls" Windows("1 Month Libor Settings.xls").Activate Range("A3:B65000").Select Selection.Copy objWorkbook.Activate Sheets("Data").Select Range("R2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Swap Reset Notice").Select Range("L15").Select Selection.Copy Sheets("Data").Select Range("L1").Select Selection.End(xlDown).Select Selection.Offset(1, 0).Select Selection.PasteSpecial Paste:=xlPasteV