error in loading dll/missing Ref Edit Control

[Ariel]

Hi All,

I am running Excel 2003.

I copied my Personal.xls file from my desktop to my laptop, and when I went
to open up Excel I got "error in loading dll". After that, when I went to run
a macro, I got another error. I then checked references and found that Ref
Edit Control is missing. I went to the location where that is, (program
files\microsoft\office11\refedit.dll) and clicked open, but that did not add
it to the library.

Any help is appreciated.

Ariel

 

[joel]

The usual problem with REFEdit is that excel doesn't recognize the the Path.
Go back into the REfernce Tool and Browse for the file and click OPen. then
make sure you have the X box slected and press OK in the Reference box. I
had the same problem a couple of years ago the 1st time I used Ref edit on my
home PC. The problem shows up as a posting quite often.

 

[Ariel]

Hi Joel,

I've got two problems, the first is the "unable to load DLL" upon startup.
That seems to set all the other problems in motion. Next, I tried loading
RefEdit and it doesn't load. Interestingly enough, this is for Office 11
directory, even thought I have it loaded from the Office 10 directory.

In any case, nothing is working here. I even tried loading the old version
of Personal.exe and that now doesn't work either.

THanks

Ariel

0I tried that and I get an error message "

 

[joel]

It will only show up in the library if you are actually using the REFEDIT
control. Try adding a userform in the personal.xls file. Then put the
REFEDIT onto the user form. Next Add the reference for the REFEDIT.

If that doesn't work create a module to the Personal.xls with three lines of
code

Sub Test
Userform1.Show
exit Sub

Next go to VBA menu Debug - Compile VBA Project.

The Refernce should automatically appear. If not, the again try to add the
reference.

Once you get it working the 1st time it should always work. this is what I
did a couple of years ago.

 

[Ariel]

Well, I still get the "unable to load dll" and so it doesn't allow me to
create or delete the userform. I think I have to resolve this load dll issue
first and foremost.

 

[joel]

Try getting to work in a regualr workbook, not personal.xls. then go back
and try the personal.xls.

You may have to reboot your pc and start from scratch. It took me a while
the 1st time on did it on my pc. I remember having similar problems, then
all of a sudden it worked. I don't know hwat I did. Don't give up.

 

[Ariel]

Hi Joel,

I removed the personal.xls file altogether and I was able to start up Excel
with no dll error message. I then put the personal.xls file back in the
directory and once again I got an error message upon start up (and of course,
that renders the personal.xls inaccessible).

Does Microsoft know of this problem? After all, it seems reasonable that you
can move your code around from one computer to another without error? My two
computers run Office 2003 products, so there is not a compatability issue.

Thanks

Ariel

 

[joel]

It should work if your have the same operating system (windowXP) and the same
version of Office. Make sure you have all the same updates (including SP's).
You also may want to copy the DLL from the PC that is working to the one
that is not working.

 

[Amedee Van Gasse]

The usual problem with REFEdit is that excel doesn't recognize the the Path.  
Go back into the REfernce Tool and Browse for the file and click OPen.  then
make sure you have the X box slected and press OK in the Reference box.  I
had the same problem a couple of years ago the 1st time I used Ref edit on my
home PC.  The problem shows up as a posting quite often.

Hi,

Sorry for the thread hijack, but we have this problem too.
A user of one department developed an Excel application that is
published on our intranet as a read-only file. The read-only part is
important here. It is a master file that should not be changed by the
users that consult it. Excel is perhaps not the best platform for what
they wanted to do, but we all know what happens when users don't get a
budget for a (.NET or other) developer...

The problem is that some users from other departments also have
missing Refedit.dll references, after a completely unrelated bugfix.
All computers at our site have the same windows and office version and
service pack. (Off2003sp2)
The bug is fixed when the reference to Refedit.dll is removed and
added back, and then the file is saved as a local copy. But we cannot
save the file to the original location, because that is read only.

I really don't know where to start troubleshooting. So far I have only
done shotgun debugging.
My next suggestion would be to change all code from early binding to
late binding so you don't need references any more, but that will have
a serious performance impact...

 

[Joel]

Try selecting a different DLL for the ref edit in the VBA Reference Menu.
Exit Excel and then swtich it back. Make sure you select the check box in
the reference menu and press OK. Then switching back to REFEDIT.DLL. I 1st
found this problem about 2 years ago. don't know why micrsoft hasn't fixed
this bug which is effecting lots of people.

 

[DonJ_Austin]

This msg thread seems somewhat related to my problem, but not completely.

On starting a .XLS workbook (developed in XL11 with VBA) in XL12, I get a
compile error "cannot find Project or library". Clicking OK, I get Reference
list showing Ref Edit Control is missing. This workbook was working fine
under XL12 - and has not been changed - since I installed SP2 for Office
2007. I remember getting such an error in similar situation startimg this
same program without having SP1 installed.

Did SP2 break what SP1 fixed ?

I tried unchecking that reference, restarting Excel and restarting the
program and got same result. I don't think it matters since the compile
error is hit on first variable not explicitly Dim'd, but it is the internally
defined Date variable, used as

DateToday = Date

Looking for help; very worried since this is a workbook/program that I
provide commercially to several clients.

Thanks.

Cheers. dj

 

[DonJ_Austin]

Got help elsewhere, but wanted to share here.

When I was installing SP2, it ran into a fata error and asked if I wanted to
return to an earlier set point. I said 'yes', and when that finished I
rebooted again and re-ran the SP2 installer. What I found out today was that
that process can remove SP1 also and it had done just that.

 

[Rob Bennett]

http://peltiertech.com/WordPress/unspecified-painfully-frustrating-error
/

I found this webpage very helpful in fixing the problem. I was trawling
around google for ages looking for a fix to the refedit issue and what's
suggested here really helped me and has fixed the problem (although it's
early days yet!).

The webpage describes several solutions, but the one that worked for me
(as an Excel 2007 user) was to "run office Diagnostics".