Cells.FormulaR1C1 between workbooks

[garden_rael]

I'm trying to copy some info from a worksheet to another...

I used a code like this in the same workbook and it works, but how can I get it to work between workbooks?

Sheets("Consulta").Cells(4, 3).FormulaR1C1 = Sheets("BASE").Cells(B, 13)

I thought it would be like
Worksheets("Tarjetas.xls").Sheets("Consulta").Cells(4, 3).FormulaR1C1 = Worksheets("Layout.xls").Sheets("BASE").Cells(B, 13)

But it didn't work.

Thank you

 

[Andrew Poulsom]

Try:

Workbooks("Tarjetas.xls").Sheets("Consulta").Cells(4, 3).FormulaR1C1 = Workbooks("Layout.xls").Sheets("BASE").Cells(B, 13).FormulaR1C1

 

[garden_rael]

hahaha didn't think of that... lol =) Thank you very much