markIngersoll
New Member
- Joined
- Apr 30, 2002
- Messages
- 1
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
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