I have written some VBA code in excel 2000 which imports one of 30 text
files, copies an area 1 column by 78 rows onto my master data consolidation
sheet, closes the imported sheet then repeats with the next one.

All works fine, except that each time excel puts up a dialog box asking me
if I want to keep the large amount of data on the clipboard -(so I have to
answer "no" 30 times...)
Is there a way to suppress this message?

Is there something like:
Activesheet.Paste SuppressAnnoyingMessageAboutClipboard:=True ?

Thanks


code within the loop is :
Windows(sourcefile).Activate
Range("B2:B79").Select
Selection.Copy
Windows("test.xls").Activate
copydest = "data" + mydate
'copydest is one of several named ranges, eg data01, data02, data03...
Application.Goto Reference:=copydest
ActiveSheet.Paste
'message appears after here
Range("A1").Select

Windows(sourcefile).Activate
ActiveWorkbook.Close SaveChanges:=False