i have a workbook with many worksheets and many macros. All are running perfectly in my pc and some other pcs of the company. But, when this file is processed in certaing pcs and when the users send me the file back by email, then i cannot run my macros. So, it seems that there is a compatibility problem between pcs and/or version of excel maybe.
When i checked with one of the users that i had compaitibility problems with, it seems that we both use exel 2003 and windows XP prof. So, i cannot understand what more i should look for when searcing for the cause of incompatibility.
Also, when i email the user back with the file that i cannot use in my pc, he reports that he's able to use it and run the macros in his pc.
And now when i save the file to my pc, it says that there is a problem loading the dll, and does not even open the modules.
When looking at it further, i first thought that my compatibility problem was just due to undeclared variables, so i put option explicit at the start of one of the modules, to identify the undeclared variables, an tried to debug the file directly from the email, without saving to my pc. But still it says:
"compile error, cannot find the project or library"
and it identifies Left, in the following code line (where aa is declared as string):
If (Left(aa, 1) = "A") Then
.........
End if
Do you have any ideas on what could be causing the problem and how i should proceed so that i could fix it? Any thoughts will be greately appreciated!!!
When i checked with one of the users that i had compaitibility problems with, it seems that we both use exel 2003 and windows XP prof. So, i cannot understand what more i should look for when searcing for the cause of incompatibility.
Also, when i email the user back with the file that i cannot use in my pc, he reports that he's able to use it and run the macros in his pc.
And now when i save the file to my pc, it says that there is a problem loading the dll, and does not even open the modules.
When looking at it further, i first thought that my compatibility problem was just due to undeclared variables, so i put option explicit at the start of one of the modules, to identify the undeclared variables, an tried to debug the file directly from the email, without saving to my pc. But still it says:
"compile error, cannot find the project or library"
and it identifies Left, in the following code line (where aa is declared as string):
If (Left(aa, 1) = "A") Then
.........
End if
Do you have any ideas on what could be causing the problem and how i should proceed so that i could fix it? Any thoughts will be greately appreciated!!!
