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!
Bookmarks