Copying data from one workbook to another?

[Freakazoid]

Hello

I am trying, once again, to avoid using copy paste in my VBA code, and have run into a problem that i cant solve.

I have a workbook called Book1, from a VBA code within this workbook i want to open another workbook, copy some data from this other workbook into the first one and close workbook two again.

i have tried the following code but gets the failure notice:

Run-time error '9':

Subscript out of range

Please Login or Register  to view this content.

Can anybody help me please?

/Freakazoid

[JBeaucaire]

When you DEBUG at the error message, which line of code is highlighted? This error frequently means it can't find something you've defined on that line of code, like a workbook name or a sheet name is wrong or unavailable in some way.

[Freakazoid]

The highlighted line of code is the fourth line:

Please Login or Register  to view this content.

/Freakazoid

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

[Freakazoid]

Thanks alot