i want to close an excel file.
i have already this code
Windows("datamppm.xls").Activate ActiveWorkbook.Close savechanges:=True Application.Quit End
but when ik click te button to close the excel file.
excel gives an "error" that there are item on the clipboard.
en then i have to chose yes or no te save them.
en than the excel file closes.
but is there no way that the excel file closes automaticly whitout the "error" of excel.
that i type some code the vb chose automaticly.
the answer must always be no.
can somebody help me with this.