Compile error, cannot find the project or library

[Son]

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!!!

 

[Son]

you lost me...
where do i do that? from the start/run?
because when i do that it does not find the file

 

[Jonmo1]

Yes, from Start - Run

You may need to add the path..

regsvr32 C:\Windows\...\...\refedit.dll

whatever the path is to where you found the file on your pc.

 

[VoG]

Yes, Start > Run

You may need to include the full path to the file.

 

[Son]

well, it said that it concluded successfully, and i'll try to reboot now, because it doesnt seem to be workign so far - will let you know

 

[Son]

so far we have this:
i successfully untick the file directly from the email. and then it runs ok, even when saved in my pc!

if i try to open a file that had been saved to my pc but was not working and i had not unticked the missing dll, then it still says: error loading dll.

so, i guess that i should untick each time when i receive the email, before saving the file to my pc. This is quite acceptable, than having to recreate the whole file from scratch!!!

thank you very much for all your help!!!

 

[VoG]

It might be acceptable but that behaviour isn't normal!

Try Detect and Repair from the Help menu in Excel.

 

[Son]

detect and repair, yes, i've tried it and it's not working either.

anyway, thanks again for all your support and help, i so much appreciate it!!!