Compile Error In Excel 2010
Contents |
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 excel 2010 compile error object library invalid 2010 - Planning, Deployment, and Compatibility Question 0 Sign in to vote Recently
Compile Error In Hidden Module Excel 2010
installed MSOffice 2010 Pro trial version and receive the following Macro error in Excel: compile error. Can't find project compile error in hidden module excel 2010 windows 7 or library. The Excel file was created with Office 2003 and runs okay with the Professional version of 2003, but not the SMBS Excel 2003. I tried setting the macro security
Compile Error In Hidden Module Excel 2010 Windows 7 64 Bit
level to low in 2010, however, the macro still will not 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. compile error in hidden module solvercode excel 2010 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 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
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 00:33:49 GMT by s_hv996 (squid/3.5.20)
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 https://liberty.service-now.com/kb_view_customer.do?sysparm_article=KB0012541 aware of an issue where, 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 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 compile error Microsoft Access or 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 compile error in the error message. Make sure the 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 submittin