Display the "File Open" Dialog Box

[mattj63]

I'm trying to open an Excel file via a macro. However, I want the user to be able to select the file rather than hardcoding the file as in the command:

Workbooks.Open Filename:= "C:Sample.csv"

Should be easy right? But I can't find it in the VBA help.

 

[mattj63]

Now I find it!

fileToOpen = Application _
    .GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen <> False Then
    MsgBox "Open " & fileToOpen
End If