System Error &H8007007E (-2147024770) The specified module cou
in [Programming]
|
Prev: Writing a Macro to Find & Delete Target Rows in a Range
Next: Error with MarcoOptions method, add a new category
From: bUncE on 27 Nov 2007 10:06 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? "JLGWhiz" wrote: > 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. > > "Steen" wrote: > > > 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 > >
From: Steen on 27 Nov 2007 15:19 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 "JLGWhiz" wrote: > 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. > > "Steen" wrote: > > > 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 > >
From: Steen on 19 Dec 2007 05:46 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. "JLGWhiz" wrote: > 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. > > "Steen" wrote: > > > 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 > >
From: Jean-Yves on 19 Dec 2007 06:35 Hi, Isn't there a missing dll (Tool?reference), different installation or missing add-in ? Regards JY "Steen" <Steen(a)discussions.microsoft.com> wrote in message news:2D6EFFAF-4BC8-4B89-A8CF-20E23145C533(a)microsoft.com... > 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. > > "JLGWhiz" wrote: > >> 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. >> >> "Steen" wrote: >> >> > 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 >> >
From: Steen on 19 Dec 2007 07:34
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 "Jean-Yves" wrote: > Hi, > > Isn't there a missing dll (Tool?reference), different installation or > missing add-in ? > Regards > JY > > "Steen" <Steen(a)discussions.microsoft.com> wrote in message > news:2D6EFFAF-4BC8-4B89-A8CF-20E23145C533(a)microsoft.com... > > 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. > > > > "JLGWhiz" wrote: > > > >> 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. > >> > >> "Steen" wrote: > >> > >> > 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 > >> > > > > |