Close workbook/clipboard thru macro

[Firefly]

I'm writing macros to generate reports from a database. I'm closing a workbook via macro after I've copied a quantity of data into another. I've been able to close the workbook automatically, but I still get the message about data on the clipboard & have to manually click save or delete. Anyway to automate that as well?

 

[Mark O'Brien]

I think this works, use DisplayAlerts like this.

<pre>

Application.DisplayAlerts = False

'Your code for closing etc</pre>

HTH

 

[Juan Pablo González]

Mark, I seem to remember that this isn't affected by DisplayAlerts. You can, however do this before closing:

Application.CutCopyMode = False

or

Range("A1").Copy

Basically, reduce the Clipboard size so Excel won't pop up the message.

 

[Firefly]

Thanks Juan - the Application... line worked just fine!