"Browse for file using the Windows Common Dialog Control."

Create a form, add the Common Dialog Control and two command buttons like
this:

Private Sub Command1_Click()
    With Me.CommonDialog1
        .ShowOpen  ' display Open common dialog box.
        MsgBox .FileName, vbInformation, "FileName"
    End With
End Sub

Private Sub Command2_Click()
    With Me.CommonDialog1
        .ShowSave  ' display Save common dialog box.
        MsgBox .FileName, vbInformation, "FileName"
    End With
End Sub

Before you invoke the .ShowOpen and .ShowSave methods, you can set the
default path, file name, etc. The documentation is rather sparse on ActiveX
controls, but used the Object Browser (open any module, press F2) to find
out the properties.