how te close excel file automaticly with vb6 ???

[P90K]

hi

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.
tankx

[Jx_Man]

see this link
http://en.allexperts.com/q/Visual-Basic-1048/Manipulating-files-Visual-basic.htm

[P90K]

thanks for the replay

but that doesn't solve my problem.
the only explain how to open and close an excel file.
i need to now how i can answer "yes" or "no" automaticly when excel asks to save te clipboard.

any idea ????