Hi Tom,

Thank you so much for your reply. It worked like a
charm. One small problem that I have now is that if I
save the file on that computer and then try and open it,
it causes a fatal error with an error report that is being
generated. Again only on some computers. If I open the
original, or don't save then it works fine. It is not too
much of a problem as the users do not need to save the
Excel app.

Thanks
Darryl


-----Original Message-----
It sounds like you have a reference to a DLL that is not
located on the
problematic machine. I would go to your machine and
check all the
references and make sure you actually need them. Remove
any that you are
not using. If you still get problems, go to the
problematic machine without
using your file and look in tools references and try to
find all the
references you have in your application. If you can't
find one or more,
then that would probably be the source of the problem.

--
Regards,
Tom Ogilvy

"Darryl Bailey" wrote in message
...
Hi,

I wrote an Excel application in Excel 97 SR-2. It works
fine on my machine running Windows NT. The problem is
that when I try and run it from some machines with
Windows
2000 on them then I get odd errors. It seems that the
program wants me to declare the variables that I used,
and
it does not recognise the VBA commands such as Str().
Also when I try and open the references dialog box, to
see
if the correct DLLs have been linked, it says that the
System Registry cannot be accessed. This however does
not
happen on all machines with Windows 2000 on them as the
program works perfectly on some of them.

Any ideas? I am really stumped.

Thanks
Darryl


.