vba variable problem

[joao]

Hi,

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

When i tried to execute the macro on the first computer (after som
work on another computer) all the variables are not being recognized
it appears an error message saying that excel could not find the th
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. bu
it used to work fine.

thank

 

[Harald Staff]

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.

 

[joao]

thanks it worked!

Next time i will declare!

 

[Harald Staff]

" I hereby declare..." ;-)
Glad it worked. Thanks for the fedback.
To be honest, those problems occur with Option Explicit and fine tuned code too. It's just
easier to spot the errors under those conditions.

Best wishes Harald
Followup to newsgroup only please.