Missing library???

P

pcor

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
 
D

Dave Peterson

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.
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top