Hi, if I have 2 instance of excel open, and i want A1 in workbook1 to
= a1 in workbook 2, what do I put in the cell. Ive tried
=Workbooks("workbook2").Worksheet1.Range("a1"). I want to create a user
form and have the labels in workbook1 = certain cells in workbook2.
Both workbooks will be open toghether always.
RegarDS rOBERT

hi

try
Workbooks("workbook1").Worksheet(1).Range("a1") =
Workbooks("workbook2").Worksheet1.Range("a1")..val ue

Regards Yngve

hi

sorry, the first answ. is for Sub VBA

Put this in "workbook1 worksheet1" Range("A1")

=[workbook2.xls]sheet1!$A$1

Regards Yngve

Hi, thanks for your reply, Unfortunatly I couldnt get either to work.
Im particully intersted in the first one. But it says its not a valied
object.
Regards Robert

Hi, got it to work with
='I:\MyDocuments\Settings\[trade.xls.sheet1]C'!$B$3. The problem Ive
got now is when the values change in trade.xls they dont update in
workbook1. Any Ideas. Thanks for your advice.
Regards Robert

hi
you need to have trade.xls open

Regards Yngve

hi
you could also try

go into

tools, options, calculation
tikk on autumatc and update remote tabels

regards yngve

hi
you could also try

go into

tools, options, calculation
tikk on autumatc and update remote tabels

regards yngve