Compile Error In Hidden Module Vba Code
Contents |
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office
Vba Compile Error In Hidden Module Excel
Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors compile error in hidden module solver code Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx
Compile Error In Hidden Module Common Code
Office VBA language reference Visual Basic language reference Error Messages Error Messages Compile error in hidden module:
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 the company
Microsoft Visual Basic Compile Error In Hidden Module Excel 2007
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions microsoft visual basic compile error in hidden module office 2007 Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million
Microsoft Visual Basic For Applications Compile Error In Hidden Module
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA Compile Error up vote 0 down vote favorite 1 We have an excel spread sheet which we use and https://msdn.microsoft.com/en-us/library/office/gg251410.aspx it works for most machines but bombs out with 'Compile Error in Hidden Module - General' on others, and the reason appears to be due to missing References. We check that Macros is enabled but still doesn't help. Since we protect this excel spread sheet with a password, we don't want to be giving this password out to our users to check the References, and wondered if anyone had any idea how I can http://stackoverflow.com/questions/18116285/excel-vba-compile-error add VBA code to check whether the References required for the excel spread sheet is there and if not then bring up a message box to advise the user. The References we use are as follows: Visual Basic For Applications Microsoft Excel 11.0 Object Library Microsoft Forms 2.0 Object Library Microsoft Windows Common Controls 5.0 (SP2) Alternatively, if anyone has any other suggestions on how to go about this problem, that would be great. excel vba reference compilation share|improve this question edited Aug 8 '13 at 1:36 asked Aug 8 '13 at 1:01 SamoanProgrammer 3542415 I don't know if there's vba for checking references, but I know that the excel object library is often different depending on the version of office installed. My suggestion would be to use late binding if the commands are the same...but there's probably a better way. –RowanC Aug 8 '13 at 1:27 Hi mate, I'm still quite new to VBA programming, so what do you mean by using late binding? –SamoanProgrammer Aug 8 '13 at 1:40 support.microsoft.com/kb/245115 –RowanC Aug 8 '13 at 1:55 thank you @SamoanProgrammer would you know how your users can add references if there is a password on the VBA code? (I have the exact same problem). chrs, BK –BKSpurgeon May 30
Forums Excel Questions Compile error in hidden module. Module 1 Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Compile error in hidden module. Module 1This is a discussion on Compile error in hidden module. Module 1 within the Excel Questions forums, http://www.mrexcel.com/forum/excel-questions/566811-compile-error-hidden-module-module-1-a.html part of the Question Forums category; Hi Guys, I am getting the above error message whenever I try to open up my spreadsheet. I am using ... 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 Jul 25th, 2011,07:56 PM #1 neo2 New Member Join Date Jul 2010 Posts 33 Compile error in hidden module. Module 1 Hi compile error Guys, I am getting the above error message whenever I try to open up my spreadsheet. I am using excel 2010 currently but the sheet was created in excel 2007. How can I solve this ? Neo Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 25th, 2011,08:02 PM #2 Smitty MrExcel MVPModerator Join Date May 2003 Location Redmond, WA Posts 29,351 Re: Compile error in hidden module. Module 1 What happens if you hit Debug? If you don't get compile error in that option, then see if you can unprotect the VBA project and try opening it again. Share Share this post on Digg Del.icio.us Technorati Twitter Smitty Every once in a while, there's a sudden gust of gravity... Check out my new book at the Mr. Excel Bookstore! Mr. Excel HTML Maker - Post a shot of your sheet Reply With Quote Jul 26th, 2011,07:32 PM #3 neo2 New Member Join Date Jul 2010 Posts 33 Re: Compile error in hidden module. Module 1 The debug option is not there. It does not allow me to do anything. The message says that this error commonly occurs when the code is incompatible with the version platform. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 26th, 2011,08:22 PM #4 Trebor76 Board Regular Join Date Jul 2007 Location Sydney Posts 3,376 Re: Compile error in hidden module. Module 1 I dare say either you've upgraded recently or someone has used and saved the file in a from different version of Excel than the file was created in as some of the DLL's are located in different path locations between versions. See if these four steps help: 1. From the file in question, press Alt + F11 go into its Visual Basic Editor. 2. From the Tools menu select References 3. Scroll through the Available References listbox and untick any that start with MISSING: 4. Press Alt + Q once all of these reference errors have been unticked. HTH Robert