Hi. I am fairly new to Visual Basic. I am trying to write code which will do the following

- Prompt user to browse and select the file they want data from
- Copy data from particular cells and store it in variables

I have made a start as shown below

Sub Prompt() 'Prompt user to select file from which to read data

Ref_Wbook = Application.GetOpenFilename("TextFiles (*.xls), *.xls") 'Command to allow browse procedure

End Sub


I guess I do not know how to address the data workbook so that I can refer to it, saying ok now that user has selected I now want to work in a 'Particular' sheet in that workbook.

Any help would be appreciated.

Thanks!