Hey everyone,
I was given a macro written by someone to modify. The original version was written in XL 2k on a win 2k OS and we recently upgraded the system to XL 03 on an XP OS. Since then - i havent gotten it to run. I can open the original and view all the code and run it but I cannot save it, close it, reopen it and run it. Once I reopen after saving and closing, I try to view the code and get a reoccurring error msg: "Error loading DLL" and all activeX functions within the code are gone. but "error loading dll" is all it will tell me.
I also get errors such as "cannot exit design mode, contol label 1 not instatiated " but I dont have a label 1 anywhere in the macro or on any worsheets. I am trying to figure out if theses are compatibility issues. We have had issues with running XL 2000 macros on XP OS so i thought maybe I would throw it out there.
Thanks a lot
I was given a macro written by someone to modify. The original version was written in XL 2k on a win 2k OS and we recently upgraded the system to XL 03 on an XP OS. Since then - i havent gotten it to run. I can open the original and view all the code and run it but I cannot save it, close it, reopen it and run it. Once I reopen after saving and closing, I try to view the code and get a reoccurring error msg: "Error loading DLL" and all activeX functions within the code are gone. but "error loading dll" is all it will tell me.
I also get errors such as "cannot exit design mode, contol label 1 not instatiated " but I dont have a label 1 anywhere in the macro or on any worsheets. I am trying to figure out if theses are compatibility issues. We have had issues with running XL 2000 macros on XP OS so i thought maybe I would throw it out there.
Thanks a lot