+ Reply to Thread
Results 1 to 10 of 10

Compile Error in Hidden Module and Compile Error: Can't find project or library

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Compile Error in Hidden Module and Compile Error: Can't find project or library

    Hi....
    I have a complex workbook that works fine in excel 2007/10/13 in my laptop.
    In other PC's and laptops too, but when i gave a friend of my the file when he tries to open it it gives this error:
    "Compile Error in Hidden Module: Thisworkbook" - he closes the error and as VBA is protected he can't see the problem. He continues to use the file and when executing another macro the same error again but refering other module.

    I said to him to try other Office versions and he tried all 3 (2007/10/13) and the problem persists.
    Then i went to his PC and unprotected the VBA project to see the error and now when open the workbook the error shows: "Compile Error: can't find project or library" and lightens the code. The same to the other macro.

    I can't see anything wrong with the code.
    I attatched 2 print screens of the errors from the two macros.

    So if anyone could help i would be really appreciate.

    Thank you
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    Check Tools | References and see if there is anything marked as MISSING


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    @TMShucks

    Thanks for the response. I'll try that. but if i see anything marked as MISSING what should i do?

  4. #4
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    @TMShucks

    Actually there is a MISSING reference in VBA.
    It's called: kiwiPluginLib

    If i uncheck it and save the workbook and then open it again it works fine. But when i protect the VBA again or send the same file protected to the PC the same error again (in this case says: Compile Error in Hidden Module. This Workbook)

    What should i do?

    I attached a picture of the Reference missing.

    Thank you
    Attached Images Attached Images

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    I have no idea what that plugin is, or what it does. I have, however, Googled it, and it looks as though it may be something to do with this:

    http://www.async.com.br/projects/kiwi/

    Kiwi consists of a set of classes and wrappers for PyGTK that were developed to provide a sort of framework for applications. Fully object-oriented, and roughly Smalltalk's MVC, Kiwi provides a simple, practical way to build forms, windows and widgets that transparently access and display your object data. Kiwi was primarily designed to make implementing the UI for Stoq easier, and it is released under the LGPL. Kiwi is inspired by Allen Holub's Visual Proxy.

    Kiwi is a framework and a set of enhanced PyGTK widgets designed to make building programs with graphical interfaces both easy to write and easy to maintain. Kiwi is pure Python and should work cross-platform, but is developed on Python 2.4, Linux ix86.
    Does that mean anything to you?

    Regards, TMS

  6. #6
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    This doesn't says me nothing at all..
    I was searching in my original workbook and there is that reference...
    Can i export it and add to the other PC library?
    It indicates a path but i cant find that name...
    Can i exclude it from my workbook?

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    As I said, I have no idea what that plugin is, or what it does.

    Sorry. If you've got a reference to it, what are you using it for?

    Regards, TMS

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    Can you post a sample workbook with any sensitive information removed?

  9. #9
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    I solved it.
    I went to the original workbook and unchecked that reference and saved it
    And know even protected in the other PC does not have the problem because it was saved without that reference.
    And even it was active it seemed to do nothing to the project itself
    Dont know where it came from but its working the same without it and solve the problem
    Thanks for the help though.

    Regards

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Compile Error in Hidden Module and Compile Error: Can't find project or library

    You're welcome. Thanks for the rep.

+ 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. [SOLVED] Compile Error: Can't find project or library (1 computer has the error, another does not?)
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 06-28-2012, 12:09 PM
  2. Compile Error: Can't find project or Library
    By ashmakda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 06:20 PM
  3. Compile Error: Can't find project or library
    By gone83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2011, 09:23 PM
  4. Compile Error - Can't find project or Library
    By bmasella in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2007, 07:55 PM
  5. Compile error: Can't find project or library
    By Vince in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2005, 12:05 PM

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