+ Reply to Thread
Results 1 to 3 of 3

Compile error in hidden module: Module 1 when workbook opened on different machine!?

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Compile error in hidden module: Module 1 when workbook opened on different machine!?

    Hi,

    I've a workbook that opens and saves perfectly and consistently on my own machine, but that sometimes gives a 'Compile Error in hidden module: Module 1' error when opened (perhaps after just one re-save) on some other PCs.

    How do I go about fault-finding?

    I've found many references to this sort of error on the web from several years ago, and had lots of problems running my file on other machines after the Dec '14 MS Security Update problem, but I think those issues are behind me.

    The machines generally differ in whether they run Office 10/13, Windows 7/8.1, and 32-bit/64bit. I obviously want to write a robust program that correctly saves/re-opens irrespective of the exact PC on which it's used.

    Should I try to isolate exactly what combinations of systems create the error, or do I run the debugger as soon as the fault is encountered, or...
    Or would it be helpful if I checked the VBA References on each of the machines?

    I really don't understand what sort of problem I've got, and hence where to (systematically) start looking.

    Thanks in anticipation for your advice. :-)

    MathUKTeacher (amateur programmer)

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Compile error in hidden module: Module 1 when workbook opened on different machine!?

    Yes references are often the culprit. The more of those you can avoid the better... when you are reaching a wide variety of windows/office verstions, it is often better to use late binding instead of early, though while coding I prefer early binding since it it more helpful with completing code (eg. "worksheet.ac" will offer "activate" right away.)
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    03-26-2014
    Location
    Nowhere, somewhere
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: Compile error in hidden module: Module 1 when workbook opened on different machine!?

    The MS help article Compile error in hidden module: <module name> indicates that the hidden module is a Protected Module and as such the debugger can not take you to the offending code. Try un-protecting the code, and running on one of the problem machines.; Hopefully that will get you to the root of the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compile error in hidden module
    By kaDargo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2013, 11:17 AM
  2. [SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  3. Compile Error in Hidden Module
    By Wikkie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2012, 08:44 AM
  4. Compile Error in HIdden module?
    By mitelkm in forum Excel General
    Replies: 4
    Last Post: 02-07-2008, 01:21 PM
  5. compile error in hidden module: This workbook
    By briggsd in forum Excel General
    Replies: 0
    Last Post: 02-07-2005, 01:14 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1