Why would this fail:
ActiveWindow.Close , savechanges:=False

Even if I stick this line before it, I still get a runtime error 5:
On Error Resume Next
I just loaded the workbook, read some data and I want to close it without
saving changes, but I am getting runtime error 5, invalid procedure call or
argument.

use

ActiveWorkbook.Close SaveChanges:=False

Regards
Nigel


"Mike H." wrote in message
...
Why would this fail:
ActiveWindow.Close , savechanges:=False

Even if I stick this line before it, I still get a runtime error 5:
On Error Resume Next
I just loaded the workbook, read some data and I want to close it without
saving changes, but I am getting runtime error 5, invalid procedure call
or
argument.