Missing library???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pcor - 26 Nov 2006 16:25 GMT

Hi all
I have a macro that starts as shown below.
j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Chr$(13)
intX = MsgBox(j$, Style)

When I try to run the macro I get an error message :"cant't find project or
library" and the first "Chr$(13)" is hilighted.If I delete the ref to
char$(13)(both of them) and rtry to run macro again , I get the same error
but this time "J$" is hilighted.
This macro has worked very well for a long time. It just started acting up
after I reinstalled winmdows- computer crashed bad.
Sure would appreciate any help

Reply to this Message

Dave Peterson - 26 Nov 2006 16:40 GMT

Inside the VBE with that project active, click on Tools|References.

Look for MISSING references in that list. Delete that reference or replace it
with an existing equivalent.

> Hi all
> I have a macro that starts as shown below.
[quoted text clipped - 9 lines]
> after I reinstalled winmdows- computer crashed bad.
> Sure would appreciate any help

Signature

Dave Peterson

Reply to this Message

JLatham - 26 Nov 2006 16:47 GMT

Style is a reserved word and may be giving you some problems. What is that
defined as?

Also, I recommend using the & (ampersand) to concatenate text rather than
using the + symbol.

If you'll go to your code section and then choose Tools | References from
the menu bar it will tell you what libraries are in use and indicate any that
are missing. Knowing the specific library that is missing will help figure
out how to fix it, unless someone else knows intutively which one it's going
to be based on the code you've shown here.

> Hi all
> I have a macro that starts as shown below.
[quoted text clipped - 9 lines]
> after I reinstalled winmdows- computer crashed bad.
> Sure would appreciate any help

Reply to this Message

Rate this thread: