Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Compile error ...

Hi,

I am getting the error

Compile error! "Cannot find project or library"

for the following code in excel.

The error is thrown for functions such as chr(), mid(), ucase() etc.

----------------------------------------------------------------------------
----------------------

'---- Username = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

Username = ""

For i = 1 To Len(lpBuff)

If Asc(Mid(lpBuff, i, 1)) 0 Then Username = Username & Mid(lpBuff, i, 1)

Next

----------------------------------------------------------------------------
----------------------

Any help would be highly appreciated.

TIA,

Gary


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default Compile error ...

Hi Gary,

Choose Tools/References from the VBE menu and you should see one of the
selected references for your project prefixed with "MISSING". Uncheck this
reference and this problem should go away (although other problems may arise
as a result of the missing reference).

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Gary" wrote in message
...
Hi,

I am getting the error

Compile error! "Cannot find project or library"

for the following code in excel.

The error is thrown for functions such as chr(), mid(), ucase() etc.

--------------------------------------------------------------------------

--
----------------------

'---- Username = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

Username = ""

For i = 1 To Len(lpBuff)

If Asc(Mid(lpBuff, i, 1)) 0 Then Username = Username & Mid(lpBuff, i, 1)

Next

--------------------------------------------------------------------------

--
----------------------

Any help would be highly appreciated.

TIA,

Gary




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 535
Default Compile error ...

Hi,

In the VBE, check Tools, references. See if any are noted
as missing. Try to uncheck those.

Other option:

Export and remove the module. Then import it again.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Hi,

I am getting the error

Compile error! "Cannot find project or library"

for the following code in excel.

The error is thrown for functions such as chr(), mid(),

ucase() etc.

----------------------------------------------------------

------------------
----------------------

'---- Username = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

Username = ""

For i = 1 To Len(lpBuff)

If Asc(Mid(lpBuff, i, 1)) 0 Then Username = Username &

Mid(lpBuff, i, 1)

Next

----------------------------------------------------------

------------------
----------------------

Any help would be highly appreciated.

TIA,

Gary


.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Compile error ...

Thank you so much, problem solved.

- Gary

"Gary" wrote in message
...
Hi,

I am getting the error

Compile error! "Cannot find project or library"

for the following code in excel.

The error is thrown for functions such as chr(), mid(), ucase() etc.

--------------------------------------------------------------------------

--
----------------------

'---- Username = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

Username = ""

For i = 1 To Len(lpBuff)

If Asc(Mid(lpBuff, i, 1)) 0 Then Username = Username & Mid(lpBuff, i, 1)

Next

--------------------------------------------------------------------------

--
----------------------

Any help would be highly appreciated.

TIA,

Gary




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver - error - Compile Error Nina Excel Discussion (Misc queries) 0 August 19th 08 09:41 PM
help with this error-Compile error: cant find project or library JackR Excel Discussion (Misc queries) 2 June 10th 06 09:09 PM
VBA Error Message "Compile Error...." Steve Excel Discussion (Misc queries) 3 July 15th 05 09:20 AM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 22nd 05 12:39 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"