Open File Dialog from macro?

[BBB]

Boss wants me to write him a macro that allows him to go select a file then
write the logic to take that file and run some logic. I've been searching
.... I found a FileSearch object but that allows me to find a file - I want
the user to see a File Open dialog and select the file. Is that possible?
If so, can someone point me towards how to do that?

BBB

 

[Kalle]

Application.Dialogs(xlDialogOpen).Show

 

[Frank Kabel]

Hi
you may use the GetOpenfileName method. e.g.
Sub test_fileopen()
Dim filename
filename = Application.GetOpenFilename
If filename <> False Then
Workbooks.Open (filename)
MsgBox "File: " & filemame & "is open"
' add your code here
else
exit sub
End If

End Sub

 

[BBB]

Thank you ... just simply didn't see that method.