David J Richardson wrote:
In article ,
"Corey" wrote:

When i close a workbook through code such as :

ActiveWorkbook.Close

I get an ERROR, prompts me to \send report to MS or not.

Have you installed the service pack that came out last week? One of the
bugs fixed could be paraphrased as "legit VBA code that worked fine in
Excel 2003 caused nonsensical crashes in Excel 2007 until we fixed it a
year later with this service pack".

I had similar crashes using the line you mention (though not every time
it was invoked, or in every place it existed in the code) until last
week's upgrade.

I've had a lot of these kind of crashes, so I'm hoping SP1 fixes it.

Another thing I've seen: with a workbook with lots of macros open, and
the VBE open, I can walk away, leave it doing nothing, and return to
find it has crashed ("Do you Excel to attempt to recover your work?").
This doesn't happen if I don't have the VBE open.

Has anyone seen anything like this, and does SP1 fix it?

Thanks, Darren