I'm having trouble with closing an Excel document from DMS. to close I
select File/Close. The user first reported that he would get a Run-time
424 error, object required. So I changed the Macro:

From:
Sub CloseMacro()
Call CloseFunction(False, False, EMPTY)
End Sub

To:
Sub CloseMacro()
Call CloseFunction(False, GetIsDirty(GetDocumentId(Workbooks.Item(1))),
Workbooks.Item(1))
End Sub


The error went away, but now close doesn't do anything. I select Close and
nothing happens. The only way to save and close the document is to select
the 'X' in the top right and close excel.

Any ideas?

Thanks

Brent Dastrup