Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
|
Hi, I'm trying to use a variable to import a text file. Is it possible to change the path and filename below to a variable? I would like to change "L:\GEAM Data.txt" to a variable "fname", which a user previously entered using Application.GetOpenFilename. [CODE]With ActiveSheet.QueryTables.Add _ (Connection:="TEXT;L:\GEAM Data.txt", _ Destination:=Range("A1"))[/CODE] …
|