2 workbooks

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

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
 
hi

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

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 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
 
Back
Top