Naming a workbook

[j_Southern]

I need to open a workbook(A) from within another workbook(B) and copy the contents of three sheets of workbook(A) into specified sheets of workbook(B)
To do this I have written the following code:-

Please Login or Register  to view this content.

This code fails at the line marked******** with the error message "Invalid use of property". I have tried several variations of this code without success and need some help please.
John

[j_Southern]

Please ignore this post as I now understand that I have stated my problem wrongly.
John