My guess is since the code worked in a new workbook, it's not the code.

I think the problem may be in the workbook itself. I think I'd try recreating
that workbook.

"stefan via OfficeKB.com" wrote:

Hi Dave,
First a correction.
Although the code worked under win XP Excel 2003 last night, it no longer
works and errors when the said line is in and does not error when the line is
not in.

Next. I never thought about taking that bit of code and run it in a different
workbook. Which i did with your recommendation.
This worked. No error and the workbook closed.
I'm lost...not that that wouldnt be easy anyway.
So i guess the error, although it happens or not with that specified line,
must come from something else.
How can i go about getting this fixed?
If i could i'd love to post my workbook if that would help you (someone) to
figure this out.

Thank you for your suggestion.

Stefan

Dave Peterson wrote:
Look for something like: drwtsn32.log or drwatson.log

But once you find it, I bet it won't help.

If it fails on that line (which looks ok to me), maybe you can try the code in a
test workbook.

Could it be that there's somekind of corruption happening with that workbook?

Hi,
Excel - shut down.
[quoted text clipped - 36 lines]
ActiveWorkbook.Close (False) '<= problem child
End Sub


--
Message posted via http://www.officekb.com

--

Dave Peterson