why error if available methods are used.

[AAB]

Thanks for your reply.
Actually the confusion i had was why it showed error on placing worksheets in place of workbooks in the above code.
But now i have found that it shows error as it does not know in which workbook it should add the worksheet.