Transfering data from one Excel file into another

Hi there,

need to find out the code in VBA to assign data from a cell in 1 excel file to a cell in another.

For example:

Cell A1 in Excel file test1, worksheet w1 should be transferred when the macro is started to Cell A1 from Excel file test2, worksheet w1.

Thanks for your help, guys and girls...

Marco.

You could put =[test2]w1!A1 in cell A1 of w1 in workbook test1

For VB, the syntax would be

Workbooks("test2").Worksheets("w1").Range("a1").Value = Workbooks("test1").Worksheets("w1").Range("a1").Value

Thanks for the advise...

I forgot to mention that the excel file is in another directory.

Say, c:\test1\workbook 26.11.07.xls

& c:\test2\workbook tomorrow.xls


and the Cell A1, worksheet w1 in "Workbook tomorrow" needs to obtain the value of Cell A1 in worksheet w1 in "workbook 26.11.07"

Need to use VBA. Final idea is, that whenever someone update one file the second automatically updates itself too.

thanks for your help