Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lee Jeffery
 
Posts: n/a
Default String error on closing worksheet


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   Report Post  
Lee Jeffery
 
Posts: n/a
Default


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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Lee Jeffery
 
Posts: n/a
Default


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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Lee Jeffery
 
Posts: n/a
Default


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   Report Post  
Junior Member
 
Posts: 1
Default

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:
Originally Posted by 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"