Monday, April 23, 2012 8:49 PM
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.
Monday, April 23, 2012 9:35 PM
Monday, April 23, 2012 9:46 PM
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)
Tuesday, April 24, 2012 9:11 PMAnother day and still no solution...I am still researching this issue beyond awaiting more replies...does the same thing on another profile as well.
Wednesday, April 25, 2012 12:07 AM
Wednesday, April 25, 2012 2:36 PM
Wednesday, April 25, 2012 7:22 PMFound 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.
- Marked As Answer by Brian Wolters Wednesday, April 25, 2012 7:22 PM