View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default No display : keep information in clipboard

Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Workbook("workbook2").close (False)

--
Regards,
Tom Ogilvy


"Alex St-Pierre" wrote in message
...
Hello,
I open a document and copy the information in the first document. When I
close the second document, I have a message which ask me if I want to keep
the information in clipboard.
Does anyone know how to stop this message ?

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Workbook("workbook2").close (False)

--
Alex St-Pierre