Copying cells from another workbook with VBA

Grrr...
I hate having to ask simple questions which I can't seem to find answers for on account of the fact they're too simple for anyone else to have posted.

I just need to know how to reference another workbook in order to copy values from cells on it to my own version of it. It's 18 pages, and I need to pull certain columns cell values from certain sheets (these columns are all fixed, no fancy statements required). I'm unfamiliar with the structure required to refer to another workbook. All I need to do is say "This workbook-Sheet1!D2:D20 = Workbook"Feb"-Sheet1!D2:D20", and so on, throughout the sheets.

I did look for solutions to this, but all of the answers are mixed in with complex statements for other simultaneous calculations... I find myself unable to pick out the small piece which I need from the mash of code I'm unfamiliar with.

mew.

Still getting -
Runtime error '9'
Subscript out of range

with the following code

Please Login or Register  to view this content.

trying to copy from the Test from workbook to the Test to workbook, names as seen in attachments.

This seems far too easy, I'm really clueless as per what I'm missing.

Worked for me. Only get the Runtime error '9' when workbook Test from.xlsx was closed

See link for copying info from a closed workbook
http://www.rondebruin.nl/ado.htm

VBA Noob

Hm, both workbooks are open. I'll check out that link, thanks.

EDIT:
Closed them both, opened them again, shebang all's well. Odd, but I'm not going to complain, thanks for the help guys.