String error on closing worksheet

[Lee Jeffery]

Hello,

Running Excel 2000 on WINNT.

Recently had a Document Management System installed only to find it interfered with running macros. The application was rolled back and a registry fix was provided to refresh the Office applications but did not delete any registry entries for the DMS.

The biggest issue we now have is an error which occurs whenever a worksheet or workbook is closed. Excel generates an error message box with the header "String # 17 (Error # 53 - File not found: DMESupp.xll). The body of the error message box contains a "?" icon and the text: String ID 34 ('filename.xls').

Does anyone have any ideas on what needs to be removed/changed to stop this type of error, please? (getting really desperate now ... )

[Lee Jeffery]

Have since discovered a project named DMEODMA.xla lurking in my VBA window. This is locked and I cannot delete it even though the application which deposited it there has been uninstalled. I strongly suspect this may be the cause of the 'String' error messages.

Can anyone suggest how I could possibly get rid of this unwanted project, please?

[Dave Peterson]

Look under Tools|Addins in Excel. If you find it there, uncheck it.

If it's not there, look in your XLStart folder. If you find it there, (with xl
closed), move it somewhere else.

Lee Jeffery wrote:
>
> Have since discovered a project named DMEODMA.xla lurking in my VBA
> window. This is locked and I cannot delete it even though the
> application which deposited it there has been uninstalled. I strongly
> suspect this may be the cause of the 'String' error messages.
>
> Can anyone suggest how I could possibly get rid of this unwanted
> project, please?
>
> --
> Lee Jeffery
>
> ------------------------------------------------------------------------
> Lee Jeffery's Profile: http://www.excelforum.com/member.php...o&userid=10889
> View this thread: http://www.excelforum.com/showthread...hreadid=380002

--

Dave Peterson

[Lee Jeffery]

Dave,

Thank you for your prompt answer.

I have no Add-ins with a check mark and could not find one listed with this name. I did, however, find it in the XLStart folder. I dragged it out of the folder and this has solved the 'String Error' message BUT if I now choose File > Open, I receive an error stating "DMEODMA.xla could not be found. Check the spelling of the file name, and verify that the file location is correct."

Is there another directory where this file should be located in order for the 'Open' command to function, please? Or is there another solution?

Many thanks to anyone who can help me with this.

[Dave Peterson]

I'd uncheck all those addins in Tools|Addins and restart excel.

Then close and restart excel. If the problem goes away, then start adding them
back one by one to see which causes the trouble.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

Lee Jeffery wrote:
>
> Dave,
>
> Thank you for your prompt answer.
>
> I have no Add-ins with a check mark and could not find one listed with
> this name. I did, however, find it in the XLStart folder. I dragged it
> out of the folder and this has solved the 'String Error' message BUT if
> I now choose File > Open, I receive an error stating "DMEODMA.xla could
> not be found. Check the spelling of the file name, and verify that the
> file location is correct."
>
> Is there another directory where this file should be located in order
> for the 'Open' command to function, please? Or is there another
> solution?
>
> Many thanks to anyone who can help me with this.
>
> --
> Lee Jeffery
>
> ------------------------------------------------------------------------
> Lee Jeffery's Profile: http://www.excelforum.com/member.php...o&userid=10889
> View this thread: http://www.excelforum.com/showthread...hreadid=380002

--

Dave Peterson

[Lee Jeffery]

Thank you Dave.

My regedit function has been disabled by the system administrator (bless his little cotton socks!). I will do some further research.

Your suggestions are much appreciated.