View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Program won't work on all computers

A couple of things. Check "Require Variable Declarations" just writes Option
Explicit at the beginning of each module. That is the compiler directive that
requires all varaibles to be declared. So even if you have that checked, if
the words Option Explicit are not at the top of themodule then variable
declarations are not required. That being said you should ALWAYS have Option
Explicit at the top of each module. There is no excuse for not declaring
variables...

Now to your problem... I would give it a 99.9% Chance that you have a
missing reference. When you go to one of the machies that does not work, if
you open up tools - references you will almost certainly find a reference
tagged Missing:
--
HTH...

Jim Thomlinson


" wrote:

Hey everyone,

I just spend a few weeks writing a program that will work on my PC but
not anywhere else.

I get a compile error which is forcing me to "Dim" all of my variables
to get to the next compiling error statement.

I check the options to make sure that I didn't have the "required
defining of variables" checkbox checked, and it still won't work.

Simple functions like Time() are not recoginzed and state that the
object or libarary is not found, but when I check the references all
the same references are checked.

What the heck is going on? Any suggestions?