I haven't heard of that one, but I would go back to your machine and work
with the original again. I would use Rob Boveys free code cleaner utililty.
http://www.appspro.com
once you have cleaned you file, save it, then test it on one of the
problematic machines.
If that doesn't work, you might want to export your code and other stuff,
then open a new file and copy over worksheets and so forth, then import your
code and forms and try using that file.
--
Regards,
Tom Ogilvy
"Darryl Bailey" <(E-Mail Removed)> wrote in message
news:020901c38f05$e2c5fb20$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> >news:0d2c01c38d7b$fa4b5280$(E-Mail Removed)...
> >> 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
> >
> >
> >.
> >
Similar Threads
