Using file browser as input to file location?

[mssbass]

I am currently asking the user for the file path location using the following code:

Private Sub OpenOrders_Click()
Dim strWhere As String
strWhere = InputBox("Enter path and file name")
DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", strWhere, True, "UPS COM Data!"
End Sub

Is there anyway to let the user use the file browser instead of having to remember the exact path?

 

[Ascentient]

Check out PHV's response at this thread

http://www.tek-tips.com/viewthread.cfm?qid=938499