i haven´t declared the variables, and didn´t use option explicit. but
it used to work fine.

You asked for trouble and you got it ;-)

it appears an error message saying that excel could not find the the
project or the library and selects a variable.

Open the VB editor, menu Tools References and uncheck everything marked
MISSING. That might or might not solve this problem. If so, declare your
variables.
--
HTH. Best wishes Harald
Followup to newsgroup only please

"joao" skrev i melding
...
Hi,

I am developing a macro in two computers. I began the work in one
comnputer, then i emailed it to my home computer where i worked a
little more than emailed it back to the first computer i used.

When i tried to execute the macro on the first computer (after some
work on another computer) all the variables are not being recognized.
it appears an error message saying that excel could not find the the
project or the library and selects a variable.

any idea on what it could be?

i haven´t declared the variables, and didn´t use option explicit. but
it used to work fine.

thanks


---
Message posted from http://www.ExcelForum.com/