Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Excel VBA crashing

excel 2000 and win XP home

I am having problems with excel crashing and giving me that horid error
report.
It happens when I want to add a new procedure using Insert, Procedure.
I have run the Office CD to repair any damage but it still occurs. I have
also received an error report once(twice now) when shutting down excel.
I am not running any other programs and have had no other problems in the
five months I have had the AMS XP2400 processor with Win XP.
Any help would be greatly appreciated.
Ta,
Martin


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Excel VBA crashing

Martin,

You need to provide more details.
What are you inserting and into what?
Post your code and you may get some help.

Regards,
Jim Cone
San Francisco, CA

"Martin Wheeler" wrote in message
...
excel 2000 and win XP home
I am having problems with excel crashing and giving me that horid error
report.
It happens when I want to add a new procedure using Insert, Procedure.
I have run the Office CD to repair any damage but it still occurs. I have
also received an error report once(twice now) when shutting down excel.
I am not running any other programs and have had no other problems in the
five months I have had the AMS XP2400 processor with Win XP.
Any help would be greatly appreciated.
Ta,
Martin



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Excel VBA crashing

Hi Jim,
Thanks for the reply, sorry for being so long in getting back.
I do not get to the stage of writing any code. Excel crashes when I press
enter after entering the new procedure name in the box of the Insert,
Procedure commands.
Excel is now crashing sometimes when I exit Excel.
Any ideas?
Ta,
Martin

"Jim Cone" wrote in message
...
Martin,

You need to provide more details.
What are you inserting and into what?
Post your code and you may get some help.

Regards,
Jim Cone
San Francisco, CA

"Martin Wheeler" wrote in message
...
excel 2000 and win XP home
I am having problems with excel crashing and giving me that horid error
report.
It happens when I want to add a new procedure using Insert, Procedure.
I have run the Office CD to repair any damage but it still occurs. I

have
also received an error report once(twice now) when shutting down excel.
I am not running any other programs and have had no other problems in

the
five months I have had the AMS XP2400 processor with Win XP.
Any help would be greatly appreciated.
Ta,
Martin





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Excel VBA crashing

Martin,

Make sure you have the latest Service Packs for both Excel/Office 2000 and
WindowsXP.
Also, one of the following remedies may help.
(The one about renaming your .xlb files and restarting is probably your best
bet.
Be aware that will remove any custom changes to your toolbars.)
'------------------------------------------------------------------

Jan Karel Pieterse 10/18/2002
public.excel.crashes

"Crashes on Exit "

- 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...;en-us;Q280504
- And this about startup switches:
http://support.microsoft.com/default...;en-us;q211481
'---------------------------------------------------------------------

Regards,
Jim Cone
San Francisco, CA


"Martin Wheeler" wrote in message
...
Hi Jim,
Thanks for the reply, sorry for being so long in getting back.
I do not get to the stage of writing any code. Excel crashes when I press
enter after entering the new procedure name in the box of the Insert,
Procedure commands.
Excel is now crashing sometimes when I exit Excel.
Any ideas?
Ta,
Martin


- snip -


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Excel VBA crashing

Hi Jim,
Thanks for the help. I will work through them and see if they fix it.
Ta,
Martin


"Jim Cone" wrote in message
...
Martin,

Make sure you have the latest Service Packs for both Excel/Office 2000 and
WindowsXP.
Also, one of the following remedies may help.
(The one about renaming your .xlb files and restarting is probably your

best
bet.
Be aware that will remove any custom changes to your toolbars.)
'------------------------------------------------------------------

Jan Karel Pieterse 10/18/2002
public.excel.crashes

"Crashes on Exit "

- 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...;en-us;Q280504
- And this about startup switches:
http://support.microsoft.com/default...;en-us;q211481
'---------------------------------------------------------------------

Regards,
Jim Cone
San Francisco, CA


"Martin Wheeler" wrote in message
...
Hi Jim,
Thanks for the reply, sorry for being so long in getting back.
I do not get to the stage of writing any code. Excel crashes when I

press
enter after entering the new procedure name in the box of the Insert,
Procedure commands.
Excel is now crashing sometimes when I exit Excel.
Any ideas?
Ta,
Martin


- snip -




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
excel Crashing SJMP Setting up and Configuration of Excel 3 March 6th 09 12:27 PM
Excel Crashing [email protected] Excel Discussion (Misc queries) 1 December 10th 07 02:23 PM
Help--Excel keeps crashing [email protected] Excel Discussion (Misc queries) 1 September 7th 05 10:22 PM
excel crashing robin Excel Discussion (Misc queries) 6 August 3rd 05 02:15 PM
excel keeps crashing kickyr Excel Programming 4 December 4th 03 09:58 PM


All times are GMT +1. The time now is 05:32 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"