2 workbooks

[RobcPettit]

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

 

[Yngve]

hi

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

Regards Yngve

 

[Yngve]

hi

sorry, the first answ. is for Sub VBA

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

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

Regards Yngve

 

[RobcPettit]

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

 

[RobcPettit]

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

 

[Yngve]

hi
you need to have trade.xls open

Regards Yngve

 

[Yngve]

hi
you could also try

go into

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

regards yngve

 

[Yngve]

hi
you could also try

go into

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

regards yngve