vba variable problem

  • Thread starter Thread starter joao
  • Start date Start date
J

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
 
i haven´t declared the variables, and didn´t use option explicit. but
it used to work fine.
Click to expand...

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.
Click to expand...

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