A question about automatically closing some "popup" windows from VBA -

I'm importing data from another spreadsheet by selecting a range and
then copying the range to the new spreadsheet (works fine, BTW).

Then, I close the original spreadsheet and get two popup boxes: (1) Do
you want to save changes? and (2) You have alot of data on the
clipboard....

I got rid of having the first one popup by using the
"Activeworkbook.close savechanges:= false" line.

Any idea how to automatically close the second type of window?

Thanks!

Is very probably you user any function like cut or copy in any time of your
project.

Put this code just befour close command :Application.CutCopyMode = False

like this:

Application.CutCopyMode = False
Activeworkbook.close savechanges:= false


bye...



"Chuck Taylor" escreveu na mensagem
...
A question about automatically closing some "popup" windows from VBA -

I'm importing data from another spreadsheet by selecting a range and
then copying the range to the new spreadsheet (works fine, BTW).

Then, I close the original spreadsheet and get two popup boxes: (1) Do
you want to save changes? and (2) You have alot of data on the
clipboard....

I got rid of having the first one popup by using the
"Activeworkbook.close savechanges:= false" line.

Any idea how to automatically close the second type of window?

Thanks!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003