Runtime Error

Question

When I attempt to open an excel file I get the following Runtime Error - Program: C:\Program Files (x86)\Microsoft Office\Office\EXCEL.EXE  This application has requested the Runtime to terminate it in an unusual way. Please contact the applications support team for more information.

I'm running MS Office 2000 on Win Vista 64 bit. Any help would be appreciated.

Answer 1

Step1:Check searching the complete computer for XLSTART and than delete the contents.

Step2: Follow the steps and check if that helps:

1.Go to the location C:\Program File\Microsoft Office\office\excel.exe

(if you are using a 64bit machine, then you would have to go to C:\Program files x86\Microsoft Office\Office\xcel.exe)

2.Right click on Excel.exe and click on Properties and then click on Compatibility tab. Check if you have any check mark in any of the compatibility mode options. Make sure you also click on the option "change settings for all users" tab at the bottom of the same screen and look for similar check boxes in the window.

3.Uncheck the option Run as Administrator option is you have it checked.

4.If you see any check boxes in the compatibility mode options, uncheck all the boxes and click on Apply and OK.

5.Try to open Excel now and check

Step3: Search for excel.xlb, *.qat and *.pip. Try searching and renaming this files. Check if excel works.

If still it doesn't work than, go for contorl panel> programs> programs & features> highlight office 2000 change> click on drop down of excel and make it NOT AVAILABLE.

Open registry: start> run >regedit> ok

Take back and then delete the EXCEL FOLDERS

Browse to HKEY_CURRENT_USER\Software\Microsoft\Office

Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office

Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office

Start> control panel> programs> programs & features> highlight office 2007> change> click on drop down of excel and make it AVAILABLE.

Answer 2

I am back to give you more inputs on the issue i am facing...

I downloaded the template known as email training template wizard from

http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC010375471&Application=XL&Version=12&Result=2#

Tried to open the template in excel 2007 as well as 2010, enabled the trusuted settings.

After that I select outlook under select application option.

Select article

add hyper link

add logo

it gave the error "Runtime error 9" Subscript out of range.

As you mentioned to hover the mouse on the error under debugging.

I put the quotes in the line:  strNewTitleName = "myArray(0)".

Then i tried running. It worked to open the outlook.

am not sure that this resoution seems to be correct, because I am unable to add the hyperlink and text.

Please help in fixing this issue. I think the code needs to debugged properly and then release teh right template on the microsoft website

Answer 3

when you get the error, go into debug mode and hover you mouse over  strTitleName  in the split function in the line before the line with the error.

 

I suspect that strTitleName is an empty string and that is why myarray is empty and causes the error.

 

I can't tell you why the code does not have a valid entry for strTitleName

 

--

Regards,

Tom Ogilvy

 

Thanks for your answer..Give me some time , I will try replicating the issue on a differnt system and will get back to you..If possible you may try replicating that and provide me the right fix..Perhaps it may be helpful to all of them who is using the email template wizard feature in Excel 2010..

Answer 4

After searching for excel.xlb as per Step3 (2) workbooks were found. I renamed both & excel now works! I didn't need to search for *.qat or *.pip files, nor do I understand what type of files they are, or why renaming the 2 workbooks was sucessful? Thanks for the help!

Answer 5

Troubleshooting steps:

http://support.microsoft.com/kb/919196

http://support.microsoft.com/kb/280504

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire