No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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] … |
|
Hi, I'm hoping that someone can help me out. The Range statement below has an issue with the right hand side of the equal sign. If I leave out the "& i", the information in the first text box is copied into all of the cells. However, I want to … |