Thread: RunTime Error 5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default RunTime Error 5

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.