0

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

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by P90K
0

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 ????

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.