change file import path through script

[markIngersoll]

hello All, I am trying to find a way to import a file from a different location than where my script is pointing to. Basically, I would like to browse to a file and let the script take over at that point.

With ActiveSheet.QueryTables.Add(Connection:="TEXT;D:Audit_parsertaxaudit." _
, Destination:=Range("B4"))

With ActiveSheet.QueryTables.Add(Connection:="TEXT;??BROWSE??" _
, Destination:=Range("B4"))

Thank you.
Mark Ingersoll