Copying Worksheets

[Hannah]

I want to copy a whole worksheet from a workbook that is not active into an active workbook, but i'm getting the error "subscript out of range" This is what i've done....any suggestions?

Workbooks("c:timesheetsexpenditureconsulting_tues.xls").Sheets(1).Copy _
after:=ActiveWorkbook.Sheets(2)

 

[Hannah]

i figured that out as soon as i replied (always the way)....ended up doing:

Workbooks.Open "testing.xls"
Workbooks("testing.xls").Sheets(1).Copy _
after:=Workbooks("result.xls").Sheets(5)

thanks.....i probably would have been puzzling for another week without some fresh input!