Value from another workbook

[gsouza]

I know this is simple but I just can't find it or remember it.
If i have two workbooks, book1.xls and book3.xls, with vba how do I get the value from book3.xls range("a1") to be in book1.xls range("a1"). I hope someone can help me because I am stuck. Thanks in advance.

[Bob Phillips]

I know this is simple but I just can't find it or remember it.
If i have two workbooks, book1.xls and book3.xls, with vba how do I get the value from book3.xls range("a1") to be in book1.xls range("a1"). I hope someone can help me because I am stuck. Thanks in advance.

As long as they are both open


Workbook("Book1.xls").Worksheets("Sheet1").Range("A1").Value = _
Workbooks("Book3.xls").Worksheets("Sheet1").Range("A1").Value

[gsouza]

Thank you I jthink you just saved my career.