VBA Code to prompt for filename to be imported

[NeedSomeAnswers]

Try this for getting the filename !

Dim sFullName As String
 
Application.FileDialog(msoFileDialogOpen).Show
sFullName = Application.FileDialog(msoFileDialogOpen).SelectedItems(1)