Reference cells in different workbook

[Sharkey90]

Hi,

I would like to copy data from a different workbook in a macro. When I do this, do you know how I can reference the other workbook? Being an amatuer, I have the following:

C:\Users\Andrew\Desktop\[Book1.xlsx]Sheet1.Sheets("Sheet1").Range("A1:A5").Value = C:\Users\Andrew\Desktop\[Book2.xlsx]Sheet1.Sheets("Sheet1").Range("A1:A5").Value

This gives me an error. Any idea of how I can do this? Basically copy cells A1:A5 in one spreadsheet into another?

Also, if possible, if 'book2' is closed and the macro is run from book 1, can a macro open book 2 then copy the data in?

Thanks!