Hi guys,

Got a strange one for you.
Last Friday, my department at work used numerous macros to perform daily tasks.
On Tuesday when we came in, they had all stopped working.

The code is basically what I have posted below. It seems that when you open a new workbook, the clipboard is being emptied and therefore the paste is failing with the following error:

"Run-time error '1004': PasteSpecial method of Range class failed"

Has anyone seen this error before? Any M$ updates that may have caused it?
I am using Excel 2003. 


   
 'copies column B to E in source worksheet
    Columns("B:E").Select
    Selection.Copy
    
    'Opens destination worksheet
    Workbooks.Open Filename:= _
        "C:\Documents and Settings\Bob\Desktop\Destination.xls"
          
    'selects the first sheet in destination worksheet
    Sheets(1).Select
    
    'attempts to paste into destination worksheet
    Range("B1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

Cheers,
Adam