On Tue, 03 Oct 2006 21:13:19 -0500, Dave Peterson
wrote:

I didn't read the whole thread, but this line:

Set WB1 = Workbooks("E:\Work\New\Backup\Backup.xls")
doesn't want any of that drive\path stuff.
Set WB1 = Workbooks("Backup.xls")
And Backup.xls has to be open already.

Same thing with v6-20061001.xls, too.

That did it !

Thanks one & all
Much appreciated.


Cheers - Kirk