Compile Error Cannot Find Project Or Library
Contents |
360 games PC games Windows compile error cannot find project or library excel 2010 games Windows phone games Entertainment All Entertainment
Compile Error Cannot Find Project Or Library Excel 2013
Movies & TV Music Business & Education Business Students & educators Developers compile error can't find project or library Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet access compile error can't find project or library 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 Lumia
Excel Compile Error Can't Find Project Or Library
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
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 microsoft visual basic compile error can't find project or library an issue where, when using a Microsoft Access or Excel document that ms access compile error can't find project or library integrates buttons or functions that need Visual Basic for Applications (VBA) or Macros to perform their duty, some
Compile Error In Hidden Module
users may encounter the 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 https://support.microsoft.com/en-us/kb/282331 Excel program having a reference 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 https://liberty.service-now.com/kb_view_customer.do?sysparm_article=KB0012541 Excel sheet or Data sheet that has 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 flaggi
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 http://stackoverflow.com/questions/507191/cant-find-project-or-library-for-standard-vba-functions 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 http://www.mrexcel.com/forum/excel-questions/605098-visual-basic-applications-cant-find-project-library.html 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Can't find Project or Library” for standard VBA functions up vote 35 down vote favorite 10 So I'm compile error 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 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 find project or 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 58.9k42209302 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 the case - I don't know which version the developers are using. I'll check. –Adam Davis Feb 3 '09 at 14:16 1 cpearson.com/Excel/MissingReferences.aspx –SmartestVEGA Dec 22 '09 at 14:05 add a comment| 4 Answers 4 active oldest votes up vote 31 down vote accepted I have seen errors on standard functions if there was a reference to a totally different library missing. In the VBA editor launch the Compile command fro
Forums Excel Questions VBA Can't Find Project Or Library Results 1 to 4 of 4 VBA Can't Find Project Or LibraryThis is a discussion on VBA Can't Find Project Or Library within the Excel Questions forums, part of the Question Forums category; I copied a worksheet that I use all the time on another laptop to a flash drive and copied it ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jan 12th, 2012,10:33 PM #1 jo15765 Board Regular Join Date Sep 2011 Posts 524 VBA Can't Find Project Or Library I copied a worksheet that I use all the time on another laptop to a flash drive and copied it to a new pc. The VBA runs perfectly on the other pc but on this 2nd pc I get a VBA Compile error of Can't find Project Or Library on this line of code Code: .SaveAs Filename:="C:\" & "_" & VBA.Left(ActiveWorkbook.Name, VBA.InStrRev(.Name, ".") - 1) & "_" & VBA.Format(Date, "mmddyyyy") & ".xls" And it is highlighting the word Date...Any ideas why it works on one PC and not on another? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 12th, 2012,10:37 PM #2 diddi Board Regular Join Date May 2004 Location Shepparton, Australia Posts 2,536 Re: VBA Can't Find Project Or Library in the VBE goto to tools>References scroll down the list and there will be on which is ticked but "MISSING". untick at save the workbook. thats it done. there must have been a 3rd party ocx on the other puta Share Share this post on Digg Del.icio.us Technorati Twitter The more you learn, the more you realise how little you know. Excel 2003 and 2010 / Win7 Code: Sub HintForGoodResults( ) If yourcode Is indented Then "it is easier to for everyone to understand" A