macro help - closing without saving & empty clipboard

[Bry]

Hi

i have a number of macro's that open and close different wokbooks to analyse
data. at the moment they run fine but i have to manualy click 'no' on saving
changes and to indicate that the large amount of information on the clipboard
is no longer required. can someone please tell me the code to enter to do
this?

many thanks
Bry

 

[Don Guillett]

One I use to close all

Sub CLOSE_ALL()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each w In Workbooks
w.Save
Next w
Application.Quit
End Sub

 

[Gord Dibben]

Application.CutCopyMode = False

Stick this in after any paste step to clear the clipboard.


Gord Dibben MS Excel MVP

 

[Bry]

Thanks Gord, that works fine.

Don, thanks for the advice but sometimes i dont want to close all workbooks
though just the current one, im typicaly using 2 or 3 at a time.