Microsoft Excel

[AliR]

The following copies data from one workbook to another

Sub CopyData()
'
' CopyData Macro
' Macro recorded and edited 22/01/2003 by ARennie
'


Workbooks.Open Filename:="O:\Accounts 02\TB Test.xls"
Range("A11:B11&quot.Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("A10&quot.Select
Windows("Annual Accounts Matrix.xls&quot.Activate
Sheets("ImportedTB&quot.Select
Range("A1&quot.Select
ActiveSheet.Paste
Range("A1&quot.Select
Windows("TB Test.xls&quot.Activate
ActiveWorkbook.Close


End Sub

At the ActiveWorkbook.Close line, I get a warning that the clipboard is full and do I wish to clear it or retain the data. I want to by pass this message and not retain the data. How do I do this?

 

[Stretchwickster]

Insert

 Application.CutCopyMode = False

after the

ActiveSheet.Paste

line Clive