Thread: 2 workbooks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline
external usenet poster
 
Posts: 80
Default 2 workbooks

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