Using this code i have opened an unkown named workbook:


Sub OpenWBook()

Dim fname As Variant
ChDrive "C:"
ChDir "C:\test"
fname = Application.GetOpenFilename()
If fname <> False Then
Workbooks.Open Filename:=fname
Else
MsgBox "LOAD WORKBOOK ABORTED"
End If

End Sub

Please could someone advise the syntax to then refer to this opened workbook.
For example i'll be using

with workbook("?????").worksheets("Test")

code here

end with

but i am unsure of how to perform this task. Also please note there will also be a further Workbook opened using the same methods described.

Thanks in Advance