Selecting another workbook to import

[bkeat]

Hi

I am a beginner with vba and I am stuck in trying to import another excel workbook with its location being flexible as the file-name will change.


This is what i got so far

Dim selectFile As String




selectFile = Application.GetOpenFilename(FileFilter:="Excel Files, *.xls*" _
, FilterIndex:=1, Title:="Open Excel file" _
, MultiSelect:=False)


If selectFile = "False" Then
MsgBox ("Please Select File!")
End If

Having difficulty in building the next block of code for the import.


I am using excel 2010.

Any help would be most appreciated.

Thanks.

 

[bkeat]

That works perfect, thank you so much.

I hope I can become this good at vba