Transfer data from 1 workbook to another

[timotai]

Hi All

I want to transfer data from one workbook to another picking out certain cells. I am trying to avoid the old copy and paste functions and just use something like this:

Workbook1.sheet1.Range("C32") = Workbook2.sheet1.Range("B52")

But I cannot get anything to work.

Can anyone help?

All help and advise is greatly appreciated!

Thanks

Tim

 

[Killian01]

if you put a .Value at the end of each of those then you should get the result you're expecting.