Excel Closes Down

[randy700]

I have several Excel 2007 spreadsheets that use macros to transfer the data to the mainframe. We interface through the IBM MQ series. The project I'm currently working on is to transfer a freight table to the mainframe.

The problem I've run into:
Every time I attempt to run the macro, it stops with a popup error message stating that Excel has encountered an error and must restart, whereupon I'm presented with a "recovered" document.

The rows of data I've processed up to the point it stops have been transferred, but I can't find any cause to make Excel crash. I'll attempt to attach a screenprint, but don't know if it will work since I've never tried before!


Randy

 

[AnotherHiggins]

Have you tried stepping through the code with [F8]?

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[randy700]

I have and the same thing happens. I have no calclations in the spreadsheet and, although it stops in the same place every time, there is nothing wrong with the data in that cell. I've even tried changing the data and deleting the entire row, but it still stops at the same point, regardless of what's there!

I have a total of 300 rows to process. I tried breaking it up into sets of 50 rows (process 50, then start again at the next row), and it STILL quits in the same place!



Randy

 

[AnotherHiggins]

My crystal ball is a bit hazy today.

- Please post the line of code that is giving you the error (and maybe a line or two before and after). You can wrap your code in tgml tags [ignore]

[/ignore] to format it properly.

- Please copy and paste whatever is in the cell/row that the line of code is dealing with when it errors out.

Actually, if we're going to get into the code itself, this thread would best fit in forum707. If you don't mind, please create a new thread in that forum including the information I've requested.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.