Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / February 2004

Tip: Looking for answers? Try searching our database.

run time error 7

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fesparza - 26 Feb 2004 20:54 GMT
when user opens excel, visual basic error
run time'7'
out of memory.
any suggestions other than excel /s ?
looking for fix....
thanks my cpu freinds.
Jan Karel Pieterse - 27 Feb 2004 14:51 GMT
Hi Fesparza,

> when user opens excel, visual basic error
> run time'7'
> out of memory.
> any suggestions other than excel /s ?

This is a default list of things-to-do when Excel exhibits startup
problems.

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, there is either an add-in or a (hidden)
workbook that is loaded upon XL's start, which bothers you.

- Try locating the XLSTART directory, move everything from there.
- In XL: Tools, Addins, note the ones checked and uncheck them one at
the time, each time restarting XL
- In XL, Tools, options, general. Check if a path is entered after
"Alternate startup file location". Clear it.

Another option is to open XL in Safe mode:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe

Also, you might try:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver

Yet another possible problem is a corruption of your toolbar
customisation file. Locate all files with extension .xlb and rename the
extension(s) to something like .old
Now try and start XL again.

Also, NAV has shown to cause "Excel caused an invalid page
fault in module VBE6.DLL".
You might try disabling the Office plug in of NAV.

Other causes may be a full TEMP folder:

In Windows 95/98 and ME

Delete all files in C:\Windows\Temp

In Windows NT/2000/XP

Find and Select C:\Documents and Settings\<user>\local settings\temp
and delete all files in there.

They are often left behind by installing programs but Excel needs the
space.

This is what MS has to say about startup problems:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504

And this about startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q211481

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
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.