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
Like this thread? Share it with others