ivan or some1..please help me

Posted by ..lokman.. on October 28, 2000 6:41 AM

i download a .xla file..the problem is when i opened it
it give n error : error in loading dll

n when i click help : it give me a message.

cannot find this file : EenLR3.hlp

which suppose in here : C\:program files\common files\microsoft shared\vba\EenLR3.hlp

where can i find this file n how can i opened this file.

thanks..regards

Posted by Ivan Moala on October 28, 2000 7:31 AM

The addin is expecting a certain library file
and cannot find it ??
Suggest you find out from the source which Dll
it is using then Een suggest an English lang Dll
Which nationality version of excel are you running

Ivan

Posted by lokman on October 28, 2000 6:22 PM

Thanks Ivan.i'm using the default excel version(i guess it is us) and the .xla file is wrote by a german..any idea how to solve it?..thanks

Posted by Ivan Moala on October 29, 2000 2:12 AM

If you can, then send me the addin...I'll have a look

Posted by lokman on October 29, 2000 2:32 AM

ok..i will..thanks Ivan.regards

Posted by Ivan Moala on October 29, 2000 10:14 PM

Re: ok..i will..thanks Ivan.regards

Thanks for sending the file. I had a look @ it
via Binary file viewer and was able to ascertain
that;
1) It is an excel 5 file
2) It is looking for a OLB file under C:\Windows\Sytem
3) The OLB file is VBADE.Olb
4) It is a German language Object library file.

Different language Olb files should really be
shiped with the addins if it is for international
use.

This particular one is avail @
ftp://ftp.microsoft.com/softlib/mslfiles/
The file is a German one = GROLB.EXE.
It extracts to;
Xlde50.olb
Vbade.dll
Vbade.olb

"Copy the object library files (VBA*.OLB) to the SYSTEM subdirectory of your Windows directory, for example in C:\WINDOWS\SYSTEM."

HTH

Ivan

Posted by lokman on October 31, 2000 3:07 AM

Zillion thanks Ivan..You such a doll..regards