If the file is closed, you still don't include the drive/path.

(You'd have to open the file first, though.)

JP wrote:

Good point, if both workbooks are open then you don't need the path.

Thx,
JP

On Feb 27, 8:57 pm, Dave Peterson wrote:
or

ActiveSheet.Copy _
After:=Workbooks("022508.xls").Sheets(Workbooks("0 22508.xls").Sheets.Count)

You don't include the drive and path in the workbooks() reference, but you do
want to qualify the Sheets.count.

Or using with/end with:

with workbooks("022508.xls")
ActiveSheet.Copy _
After:=.Sheets(.Sheets.Count)
End with



--

Dave Peterson