+ Reply to Thread
Results 1 to 7 of 7

Compile error: Can't find project or library

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    12

    Compile error: Can't find project or library

    Hi,

    I'm new to VBA programming, and when opening a file from my teacher I encountered a problem. I activated Macroes and got the following message: "Compile error: Can't find project or library" where

    "Function expectedTailLoss(obs, cut)" and "nrOfObs =" was highlighted.

    I have tried to read on the net and in this forum, but most suggest to press "Reset", go to "tools" and "references" to add what is missing. But whenever I press Reset I get the same message and it is not possible to press "References".

    I need to say that the file works with no problems on a lot of other computers.

    Additional information: I run Windows Vista.
    I have added the solver and the different toolpacks.

    Please Login or Register  to view this content.

    Any help is greatly appreciated - thank you in advance

    Regards
    Thomas

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Compile error: Can't find project or library

    Here are possible hints
    http://www.cpearson.com/excel/MissingReferences.aspx
    http://www.idautomation.com/kb/vba-compile-error.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-04-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Compile error: Can't find project or library

    I have tried to do what is described in both links. Unfortunately it didn't work. As I wrote in my first post, my problem is that I can't choose "tools" and "references", so I can't see witch (if any) references is missing.

    Any other suggestions?

    Thanks

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Compile error: Can't find project or library

    Do you have a Developer Tab? Perhaps you need to Customize your toolbar to see what you need.

    http://www.youtube.com/watch?v=OhSdIBdXzzg

  5. #5
    Registered User
    Join Date
    11-04-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Compile error: Can't find project or library

    Ok, that helped a little I have found out that this is what is wrong:

    "Missing:DSAFO32 - Datastream Office Datacontrol like OCX"

    It doesn't help to un-check to box, because it is needed to make the sheet work.

    I have tried google but I seem to find only dead ends. Du you know how I get the DSAFO32 add in?

    Thanks

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Compile error: Can't find project or library

    Searching like mad and only find stuff like:
    http://www.fas.nus.edu.sg/RePEc/data...troduction.pdf

    hope that helps.

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Compile error: Can't find project or library

    Have you tried asking your teacher?
    Remember what the dormouse said
    Feed your head

+ 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