that does not work for me. here is the code in excel that i am trying to bypass:
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim bSaveOrNot As String
On Error GoTo errtrap
If bChangedAndNotSaved = True Then
bSaveOrNot = UCase(InputBox("You have made changes to the data, but have not yet saved to the Server, do you want to save now?", , "Y"))
If bSaveOrNot = "Y" Then
Call Edoc
Else
bchangesMade = False
End If
End If
...
I cant change any code in the excel file. I am working in access, pulling data out of the excel form, but i cant close the excel application bc of this before close event in excel.