Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() 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 ------------------------------------------------------------------------ Lee Jeffery's Profile: http://www.excelforum.com/member.php...o&userid=10889 View this thread: http://www.excelforum.com/showthread...hreadid=380002 |
#2
![]() |
|||
|
|||
![]() 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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]() 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 |
#5
![]() |
|||
|
|||
![]()
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 |
#6
![]() |
|||
|
|||
![]() 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. -- 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 |
#7
![]() |
|||
|
|||
![]()
Thank you Dave and thank you Chip. I had the same problem and followed the instructions on Chip Pearson's website. In my case, I had to remove my *.xlb customised toolbar to fix the problem.
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |