[RESOLVED] Excel: eliminate warning about saving changes?

[krtxmrtz]

I have an Excel spreadsheet in a web site. It is write-protected but changes are automatically made because of date/time-related functions. Is it possible to configurate it such that it won't ask about saving changes when it is closed?.

[Hack]

I think something like this would work

xl.Application.DisplayAlerts = False

[krtxmrtz]

I think something like this would work

xl.Application.DisplayAlerts = False

It didn't work. Am I doing it right?

Private Sub Workbook_Open()
    Application.DisplayAlerts = False
End Sub

I tried to place it in the procedures Workbook_Deactivate and Workbook_BeforeClose as well to no avail.

[krtxmrtz]

For now I can make do with this, though it's not too elegant -kind of makes me feel like I'm cheating

Sub Workbook_BeforeClose()
   SendKeys vbTab
   SendKeys vbCr
End Sub

[RobDog888]

If you mark the workbook as already being saved then when its closed it wont prompt you to save it. This will work.

Sub Workbook_BeforeClose(Cancel As Boolean)
    ActiveWorkbook.Saved = True
End Sub

Moved from General PC forum.

[Hack]

[color=navy]Moved from General PC forum.

Thank you sir!

Nice little tip as well!

BTW: In Access, to accomplish this you would do

Axs.DoCmd.SetWarnings = False

Is there a handy dandy way of fooling Access as you have demonstrated can be done with Excel?

[krtxmrtz]

If you mark the workbook as already being saved then when its closed it wont prompt you to save it. This will work.

Sub Workbook_BeforeClose(Cancel As Boolean)
    ActiveWorkbook.Saved = True
End Sub

Moved from General PC forum.

Oh yes, sir, it does work! Thanks a lot. And btw I hadn't even noticed there was an Office Development Forum