code won't run

's Computer Specifications

I wrote some code in Excel 2003 but I can't get it to run in Excel 2000. The
real problem is that I don't know why. The current line of code is:

MsgBox "Some required information is missing." & Chr$(10) & "Please
ensure all entries are complete." & Chr$(10) & "This file has not been
saved.", vbCritical, "Missing Information"

It gives me an error at the Chr$ part. The error is

Compile Error: Can't find project or library

What is wrong?

's Computer Specifications

In the VBIDE, go into Tools>References, and if there re any items marked as
MISSING, uncheck them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Keith" <(E-Mail Removed)> wrote in message
news:29852D63-FCFB-4CF2-BACE-(E-Mail Removed)...
>I wrote some code in Excel 2003 but I can't get it to run in Excel 2000.
>The
> real problem is that I don't know why. The current line of code is:
>
> MsgBox "Some required information is missing." & Chr$(10) & "Please
> ensure all entries are complete." & Chr$(10) & "This file has not been
> saved.", vbCritical, "Missing Information"
>
> It gives me an error at the Chr$ part. The error is
>
>
> Compile Error: Can't find project or library
>
>
> What is wrong?

's Computer Specifications

Hi Bob,

That worked a treat. Thanks.

Regards

Keith

"Bob Phillips" wrote:

> In the VBIDE, go into Tools>References, and if there re any items marked as
> MISSING, uncheck them.
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Keith" <(E-Mail Removed)> wrote in message
> news:29852D63-FCFB-4CF2-BACE-(E-Mail Removed)...
> >I wrote some code in Excel 2003 but I can't get it to run in Excel 2000.
> >The
> > real problem is that I don't know why. The current line of code is:
> >
> > MsgBox "Some required information is missing." & Chr$(10) & "Please
> > ensure all entries are complete." & Chr$(10) & "This file has not been
> > saved.", vbCritical, "Missing Information"
> >
> > It gives me an error at the Chr$ part. The error is
> >
> >
> > Compile Error: Can't find project or library
> >
> >
> > What is wrong?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linq to XML--Are there code examples that make Linq as easy as SQL? Or how can I convert ths simple pseudo code into real code?	Reece	Microsoft C# .NET	4	10th Dec 2008 03:13 AM
ATI Radeon Drivers - Code 43, Code 37 & Code 10	=?Utf-8?B?SmFrZQ==?=	Windows Vista Hardware	14	29th Aug 2006 05:50 AM
ATI Display Drivers - Code 43, Code 37, Code 10	Jake	Windows Vista Hardware	2	8th Jul 2006 04:00 PM
what is the difference between code inside a <script> tag and code in the code-behind file?	keithb	Microsoft ASP .NET	1	29th Mar 2006 02:00 AM
[New] Zipoid - ZIP Code, City Name and Area Code Lookup - Zip Code to Zip Code Distance Calculation	Mel	Freeware	0	22nd Jul 2005 04:13 PM