Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Registry
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Registry
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Registry
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Registry
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" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
error accessing system registry | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
Registry | Excel Programming | |||
Registry | Excel Programming |