Missing library???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top