Clear data from clipboard using VBA

[tom]

HI everyone

I am running a loop that gathers information from one workbook to another. I get a message asking if I want to save the inforamtion on the clipboard for further use. I don't want to save this information so how can I stop this from happening

For x = 0 To
m = b -
bb = Format(m, "yyyymmdd"
Sheets.Ad
ActiveSheet.Name = b
Range("A1").Selec
Set mybook = Workbooks.Open("Test - " & bb)

Sheets("Test1").Activat
Columns("b:f").Selec
Selection.Cop

Windows(newbook).Activat

Selection.PasteSpecial Paste:=xlValues, operation:=xlNone, skipblanks:=
False, Transpose:=Fals

mybook.Close Fals

Here is a portion of the loop that is causing the information to be placed on the clipboard. Is it possible to clear it with the pastspecial formula

Thank you for any insight you may have

Tom

 

[Frank Kabel]

Hi
try
...
Application.displayalerts = False
mybook.Close False
Application.displayalerts = True

Note: this does not clear the clipboard, just prevents the message

 

[Robin Hammond]

This is meant to clear the clipboard although I recall some problems with it
in Excel 97.

Application.CutCopyMode = False

Robin Hammond
www.enhanceddatasystems.com