Excel 2007 crashes when I open a file with vba code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open a file wich contains macro's excel 2007 crashes and trys to
restart.
Tried to reinstall Office with "repair", with no succes. At the end I have
uninstall the office application, and then install it again. Still the same
problem. Who can help?
 
I have been given a spreadsheet created in XP Pro with 2003 Excel. I was
able to open and use it with the same setup. I now have XP Pro with 2007 on
a completely new system.

When I attempt to open the file from the email attachment it acts like it is
going to open in 2007 for a few seconds. I can see the file and it looks
correct. It then shows the EUROTOOL.XLAM in the bottom of the 2007 Excel for
a second and then gives me the - Do you want to send Microsoft error notice.

I have duplicated the same results on another new system with XP Pro and
2007 Excel.

Any suggestions?
 
Thank you Ron. I removed EUROTOOL.XLAM as an Add In. File will still not
open and quickly promps me to the MS Send Erro message.

I have also gone back to the MS CD that came with the unit and installed all
available from CD. No change when opening the excel file. Still routes to
MS Send Error message.

Tom R.
 
I see now that you try to open the file from your mail program .

Do you have the same problem when you save it to your harddisk first
 
Yes - same response.

The file looks like it is going to open. It is open on the screen for a few
seconds before the MS Error notice.

By selecting either button, send or don't send, the error message appears
again. After selecting either button the second time, the file opens with no
formatting (no formulas / dates / colors).
 
Try to open Excel in Safe modus and then open the same file from your harddisk

Close Excel
Hold the Ctrl key when you open excel and say yes in the dialog that popup
 
Same process happened as stated before.
Opened Excel in Safe mode.
Opened file.
MS error report
yes
MS error report
Opens with no format.
 
If it is always the same file that it is possible that it is corrupt.

You can try to clear your Temp folder

Close Excel
Start>Run
Enter this %temp%
OK
Delete all files and folders in the folder that will open


Good night
 
Same results after deleteing temp files.

Ron de Bruin said:
If it is always the same file that it is possible that it is corrupt.

You can try to clear your Temp folder

Close Excel
Start>Run
Enter this %temp%
OK
Delete all files and folders in the folder that will open


Good night
Click to expand...
 
Solution

Hi guys,

I has this same problem and went nuts for two days trying to solve it. I had an excel file on my old laptop, then bought a new laptop, and put the same Office 2007 install on it (yes microsoft, I will remove the copy off the old laptop!). I could open previously saved files from the old laptop but, after i saved them on the new laptop, they wouldn't open on the new one, but still would on the old one. The file would open ok, but when I enabled the macros, excel would just freeze. It didn't make any sense as it was exactly the same office installation, so i completely formatted my new computer and reinstalled the whole OS and everything... still didn't work. After two days I was nearly crying!!

Anyway, getting to the point, just go to Microsoft and download Service Pack 2 for Office 2007. Its about 300mb, but solved the problem instantly. Hopefully this will save some grief for someone else!!
 
I don't know if this applies to your problem but hear this out...
I've had the same problems with a fairly straightforward spreadsheet with vba code...
Looked into removing all add-ins, especially active-x ones, nope... Tried rewriting the code, spend hours trying to figure out where I missed out, nope.

I got very frustrated writing code for 10 minutes and then oups, another crash.

I must have saved about 50 different incremental version of my spreadsheet and it was very hard to keep track of the logic of my code under these conditions...
It got to a point where I could 'sense' Excel was about to crash : Quick save ! Naw, too late. Then it hit me ! Turned off AutoSave and bingo ! Never had that problem again.
Hope this helps...
 
Back
Top