Hi Guys I hope someone out there can help me.

I have a excel document which I have been using for some time without
problem.

I have recently tried to edit a macro in it and when I re-load the file
I keep getting the error "Error Loading DLL" and appears to have eaten
allof my code.

If I load the original file it runs OK
If I just re-save it, there's no problem
If I edit the macro, it runs OK
If I edit the macro then save the file and re-open it, I get the error.
Even if I only open the VB window, and then close and save the file, I
still get the error.

I've checked my temp folders etc and they are totally empty.
I've looked for a DLL file of zero size and not found one
I'm not sure if I'm being paranoid but loading Excel appears to really
slow down when I've had the problem, and I have to reboot to get its
performance back.

I am running Office 2000 with Windows XP.

Does anyone have any idea what I should try next please

Regards
Pete



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Peter,

I really don't know if this is the solution but if you haven't already you
could check the project references (tools, references) in the vba editor and
see if there are any files there that look suspect, that you don't need,
that may be causing the errors, etc. It might be that you have a corrupt dll
file on one of these references. If that doesn't work try exporting all the
modules and forms, create a new file with a clean vba project in it, check
the references are ok, import the modules and forms to the new project, and
try adding any references you need one by one to see if you can find out
which one may be causing the problem.

Good luck,

Robin Hammond
www.enhanceddatasystems.com


"Peter" wrote in message
...

Hi Guys I hope someone out there can help me.

I have a excel document which I have been using for some time without
problem.

I have recently tried to edit a macro in it and when I re-load the file
I keep getting the error "Error Loading DLL" and appears to have eaten
allof my code.

If I load the original file it runs OK
If I just re-save it, there's no problem
If I edit the macro, it runs OK
If I edit the macro then save the file and re-open it, I get the error.
Even if I only open the VB window, and then close and save the file, I
still get the error.

I've checked my temp folders etc and they are totally empty.
I've looked for a DLL file of zero size and not found one
I'm not sure if I'm being paranoid but loading Excel appears to really
slow down when I've had the problem, and I have to reboot to get its
performance back.

I am running Office 2000 with Windows XP.

Does anyone have any idea what I should try next please

Regards
Pete



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Robin

Thank you I think that got it.

As you suspected there was a reference to a file the list said
"MISSING:XviewOca Active X Control Module" it then even told me where
the file should be and what it should be called
"C:\windows\system32\XViewOcalib.TWD".

The thing that threw me was that it did exist where it was meant to.

Anyway to cut a long story short I deleted the file as suggested on
http://support.microsoft.com/default...b;en-us;244064.

I have now removed the reference to that file, and can save it and edit
it as normal.

Thanks for you help

Peter


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!