Macro to Prompt to import data

[wilgry]

I need an excel macro to prompt to import data; I do not need it to actually import the data. I need it to call up the import command found under tool bar-data-import external data-import data.

[raypayette]

Sub import()
yn = MsgBox("Import data?", vbYesNo)
If yn = vbYes Then
'do something
End If
End Sub

[wilgry]

I need the macro to actually call up the import eternal data command. The user would then choose the location of file they want to import, and finish the import process. My macro needs only to call up the import external data command.

Thanks in advance