refer to a cell in 2 different workbooks

[instanceoftime]

elementary but I just can't get it right

my code is in master.xls

user will be opening slave.xls

I need to read master.xls cell c1 into txtbxMaster.text
I need to read slave.xls cell c1 unto txtbxSlave.text


Slave.xls file will be opened via

NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file")

If NewFN = False Then
' They pressed Cancel
MsgBox "Stopping because you did not select a file"
Exit Sub

Else
Workbooks.Open Filename:=NewFN
End If

(this is a start to a long journey )

 

[GlennUK]

Once you've opened the slave workbook, store a reference to it, like:

Set wbkSlave = ActiveWorkBook

You can then use wbkSlave to refer to the slave workbook in your code, like

xxx = wbkSlave.Sheets("blah blah).Range("C1").Value

... and use the ThisWorkBook keyword to refer to the workbook where the code resides.