+ Reply to Thread
Results 1 to 6 of 6

Compile Error: Can't find project or library. Windows vs MAC issue?

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    Compile Error: Can't find project or library. Windows vs MAC issue?

    A workbook I've developed in Excel 2010 for Windows, using VBA code (Userforms, databases, etc), has problems when opened in Excel 2010 on a MAC.
    After Macros have been accepted, when one of the Command Modules is selected to open a UserForm, the VBA editor opens up and this Compile Error appears: "Can't find project or library".

    It works fine on any Windows system. What is needed to make it work on a MAC?


    Thank you.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Compile Error: Can't find project or library. Windows vs MAC issue?

    check tools-references in the vb editor and look for a checked item marked with 'MISSING:'
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    Re: Compile Error: Can't find project or library. Windows vs MAC issue?

    Nothing is marked as MISSING

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Compile Error: Can't find project or library. Windows vs MAC issue?

    I honestly don't see how that can be. what references are checked? (you do have that workbook open and active?)

  5. #5
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    Re: Compile Error: Can't find project or library. Windows vs MAC issue?

    ok. I just opened the Workbook in Excel for the MAC myself, and indeed, MISSING: Ref Edit Control

  6. #6
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    Re: Compile Error: Can't find project or library. Windows vs MAC issue?

    Thank you Joseph!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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