Still save-dialog prompt after displayalerts set to false

[stef.ong]

This is some code I used in a macro :

Application.DisplayAlerts = False
ActiveWindow.Close SaveChanges:=False
Application.DisplayAlerts = True

On some PC it is closing the file without prompting a dialog to save or not save the file. However on another PC it still prompt for this info ???
Same Excel 2000 SP3 is used on all 4 PC

Does anyone has a clue ??

 

[stef.ong]

Eric,

I agree but how can you do this.

If code is running and it stops itself by closing the .xls file, is there a possibility to have a post-mortem run or something like that?

In my opinion structuring will not do the trick since de code was stopped by the closing and not by getting to the end of it.

I'll checkout Thusharm's site.

Regards,
Stef.

 

[erik.van.geit]

In my opinion structuring will not do the trick since de code was stopped by the closing and not by getting to the end of it.

by "structure" I meant: run the code from a workbook which is NOT closed before the code reaches the end

as to open a workbook even when the sourceworkbook is closed, see this nice example

Sub GoodbyeAndHello()
    Application.OnTime earliesttime:=Now(), procedure:="OpenMe"
    ThisWorkbook.Close savechanges:=False
End Sub

Sub OpenMe()
    MsgBox "Hello again"
End Sub

but I would avoid this workaround-technique