Compile Error Can T Find Project
Contents |
360 games PC games compile error can't find project or library Windows games Windows phone games Entertainment All Entertainment
Compile Error Can't Find Project Or Library Excel
Movies & TV Music Business & Education Business Students & educators
Compile Error Can't Find Project Or Library Visual Basic
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Compile Error Can't Find Project Or Library References Greyed Out
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 compile error can't find project or library excel 2013 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
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Excel 2010 macro compile error: can't find project or library Microsoft Office > Office 2010 - Planning, Deployment, and Compatibility compile error can't find project or library access 2010 Question 0 Sign in to vote Recently installed MSOffice 2010 Pro trial version compile error can't find project or library excel 2007 and receive the following Macro error in Excel: compile error. Can't find project or library. The Excel file was created with compile error can't find project or library excel 2010 Office 2003 and runs okay with the Professional version of 2003, but not the SMBS Excel 2003. I tried setting the macro security level to low in 2010, however, the macro still will not https://support.microsoft.com/en-us/kb/282331 run. Wednesday, October 13, 2010 2:59 PM Reply | Quote Answers 3 Sign in to vote Hi, Most likely, the application has lost the reference to an object or type library resulting in the above error when using Barcode Macros & Native VBA Functions. The problem may be resolved as follows: 1. Open the database or application. 2. Open a module in Design view or press ALT+F11 to https://social.technet.microsoft.com/Forums/office/en-US/09288f15-72a0-4410-84be-cfb5e87908b6/excel-2010-macro-compile-error-cant-find-project-or-library?forum=officesetupdeployprevious switch to the Visual Basic Editor. 3. On the Tools menu, click References. 4. Clear the check box for the type library or object library marked as "Missing:" An alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box. If the referenced file is in a new location, clear the "Missing:" reference and create a new reference to the file in its new location. Microsoft has documented this issue: VBA Functions Break in Database with Missing References Regards, Harry Yuan Proposed as answer by Harry Yuan Thursday, October 14, 2010 8:41 AM Marked as answer by sacjac Thursday, October 14, 2010 1:10 PM Thursday, October 14, 2010 8:41 AM Reply | Quote All replies 3 Sign in to vote Hi, Most likely, the application has lost the reference to an object or type library resulting in the above error when using Barcode Macros & Native VBA Functions. The problem may be resolved as follows: 1. Open the database or application. 2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor. 3. On the Tools menu, click References. 4. Clear the check box for t
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/11533494/i-am-getting-compile-error-cant-find-project-or-library-in-a-only-some-excel the company Business Learn more about hiring developers or posting ads with us Stack Overflow http://www.cadsharp.com/blog/solidworks-api-compile-error-cant-find-project-or-library/ 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 I am getting 'Compile error: Can't find project or library' in a only some Excel 2010 versions. Difficult to compile error test this up vote 4 down vote favorite 1 My customer is getting a Compile Error; Can't find project or Library on his version of Excel 2010, however i am not getting this on my version of 2010. How can i adjust this code so it will not appear. When the error appears in the following code the text "cell" in "For each cell in selection" is highlighted: Private Sub Worksheet_Change(ByVal Target compile error can As Range) If Target.Address = "$B$9" Then Columns("D:CB").Select Selection.EntireColumn.Hidden = False Application.ScreenUpdating = False Sheet17.Range("E48:CB48").Select For Each cell In Selection If cell = 0 Then Range(cell.Address).EntireColumn.Hidden = True End If Next Application.ScreenUpdating = True Sheet17.Range("b9").Select End If End Sub` My customer is also reporting a bug in the following code with the word "Response" being highlighted. This, as well, is not an issue for me, on my version of Excel 2010. Any and all help is greatly appreciated. If Sheet1.Range("E18") = 3 Then Response = MsgBox("Reminder Emails have been set to be sent automatically at " & Sheet1.Range("f18").Value & ", " & Sheet1.Range("Q4").Value & " day(s) before" & vbCrLf & "the scheduled appointment. Do you want to send reminder e-mails now anyway?", vbYesNo) If Response = vbNo Then Exit Sub End If End If excel vba excel-vba error-handling compilation share|improve this question edited Jul 19 '12 at 0:36 Siddharth Rout 91.1k11102146 asked Jul 18 '12 at 2:26 raphuket 501311 You are using Response to hold a long variable so this shouldn't be trigering an error (unless perhaps Response is part of the object model of a library reference - guess). I would use lngResponse for the name and dimension it as long. –brettdj Jul 18 '12 at 3:22 1 This may be ident
written your first "serious" SolidWorks API macro. You're ready to share with your co-workers. You fire up your email, attach the macro, and click Send. Expecting an avalanche of compliments, you instead get several responses from your co-workers telling you that the macro doesn't run. "Doesn't run?! How can that be? It runs fine on my computer!" You ask for a screenshot of the error and this is what they send you: Has this ever happened to you? Maybe not in this exact scenario, but the infamous "Compile error: Can't find project or library" error message eventually befalls every API programmer trying to share their VBA handiwork with others. Fortunately, it isn't that hard to fix. The Cause When you write code with the SolidWorks API, you constantly use what are called "API calls". These are the functions you use in your code to execute commands in SolidWorks. Visual Basic for Applications, however, can't make heads or tails of these API calls unless your code references the appropriate libraries. By libraries I mean the .dll and .tlb files created by SolidWorks Corporation that define each SolidWorks API call. Some of the more common ones include: SolidWorks 20XX Type Library SolidWorks 20XX Commands type library SolidWorks 20XX Constant type library SolidWorks 20XX Extensibility type library Etc. You can see this list if, while in the VB Editor, you go to Tools->References. If you click on one of these listings, you'll also see the file path for the type library. When you create a new macro on your computer, the macro looks at these paths for the references. The problem occurs when you transfer that macro to another computer that has these references in a different location. If your macro can't locate a reference, you may see the word "MISSING" before the missing reference, but not necessarily. The Solution At the computer where the error is occurring, open up the macro in the Visual Basic Editor. Go to Tools-References, which displays a list of the libraries your macro is referencing. Do you see "MISSING" before any of the checked listings at the top? (Example) If yes, then try this first set of instructions. Otherwise, skip to the second set of instructio