Spreadsheet With CAN'T FIND PROJECT OR LIBRARY errors...

Question

We have a spreadsheet that works for everyone except one person. When she gets to a point in the Marco, it will say:

"CAN'T FIND PROJECT OR LIBRARY"

This worked for her before until she got replacement PC (her other one died and this was a PC used by someone else at one time and NOT a clean install) and the sheet has not worked since. I made sure that Marcos were on lowest security settings (our default here), made sure the VBA editor was looking at the right libraries (according to fixes in some internet searches I found) and I still cannot get it to work. Again, it is ONLY on her PC.

Suggestions?

Thanks!
Brian

Answer 1

So what application is this?
What versions are installed on her PC and yours?
What is the code that creates the error?

Have you tried a repair of her Office installation followed by a reboot?

---

Rod Gill

The one and only Project VBA Book Rod Gill Project Management

Answer 2

Sorry about that:

Excel 2003 Professional (all current updates)
The majority of the office is on Office 2003...I and a handfull of others are on Office 2010 and have to problems either.
We did repair installs and complete reinstalls...
It generally fails here:

Public Function Get_User_Name() As String

     ' Dimension variables

     Dim lpBuff As String * 25

     Dim ret As Long

     ' Get the user name minus any trailing spaces found in the name.

     ret = GetUserName(lpBuff, 25)

     Get_User_Name = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

End Function

Answer 3

Another day and still no solution...I am still researching this issue beyond awaiting more replies...does the same thing on another profile as well.

Answer 4

Try Application.Username  It certainly works in Project and Excel 2010, but I don't have Excel 2003 to test it on.

---

Rod Gill

The one and only Project VBA Book Rod Gill Project Management

Answer 5

Try Application.Username  It certainly works in Project and Excel 2010, but I don't have Excel 2003 to test it on.

---

Rod Gill

The one and only Project VBA Book Rod Gill Project Management

Pardon my ignorance, but where do I try this at? In the code? A reference modification? Thanks...

Answer 6

Found the fix...it didn't show the first time. I found the MISSING reference, downloaded it and pointed the reference to it and it works.