 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008System Error &H8007007E (-2147024770) The specified module could n
Hi I have been using a excell sheet with out any problem for several month, but suddenly one member in the group can't save the excell file. He get's the following message: "System Error &H8007007E (-2147024770) The specified module could not be found" Followed by a message: "Out of memory". Can anyone help me out here? They are all running Excell 2003 SP2 /Steen Check his hard drive status for disc space. Also check his application open and workbook open events for autorun macros or change event macros that might be firing repetitively. Shut the system down before doing the checks, and do the checks before trying to open the particular file. Then do the checks again after opening the file. This might lead you to the problem area. > Hi > [quoted text clipped - 12 lines] > > /Steen Same error for me earlier, strange eh.... Mine was just a simple frmUserForm1.Show code, i produced the same error after playing around a bit. You dont work in Brighton by any chance? > Check his hard drive status for disc space. Also check his application open > and workbook open events for autorun macros or change event macros that might [quoted text clipped - 18 lines] > > > > /Steen Hi JLGWhiz Thanks for you answer - I will for sure try this tommorrow. Would it be possible to give me a little more information on how to check his "application open and workbook open events for autorun macros" - I'm not sure how to do that. I have an event macro that migth be the problem, but it's just strange that is this is then not a problem to the other users. /Steen Denmark > Check his hard drive status for disc space. Also check his application open > and workbook open events for autorun macros or change event macros that might [quoted text clipped - 18 lines] > > > > /Steen Hi again I have now tried the below without any luck. 1. There is 50% free diskspace and memory 2. Comment out eventmacros and open macros: This did make a change, but the messages showed up again when saving :-( 3. Don't use macros at all - ok, but then the idee behind the sheet is gone :-( 4. 7 other people have no problem in using the excel sheet - strange! 5. I have updated the machine with latest updates for XP and Office 2003. > Check his hard drive status for disc space. Also check his application open > and workbook open events for autorun macros or change event macros that might [quoted text clipped - 18 lines] > > > > /Steen Hi, Isn't there a missing dll (Tool?reference), different installation or missing add-in ? Regards JY > Hi again > [quoted text clipped - 38 lines] >> > >> > /Steen Hi Jean-Yves Thanks for your quick reply :-) I will try to check that tomorrow - unfortunately my son has become sick today. I will give you a note on wehter it solved the problem > Hi, > [quoted text clipped - 45 lines] > >> > > >> > /Steen Hi again Jean Yves Sorry for the deleay - but the person who had the problem has been on vacation. We have now tried all your suggestions, but unfortunatuly without any luck. Our IT department is now on the issue... Any other suggestions? > Hi Jean-Yves > [quoted text clipped - 54 lines] > > >> > > > >> > /Steen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.