ransomedbyfire
Board Regular
- Joined
- Mar 9, 2011
- Messages
- 121
I am importing two columns of data from two different text files. The data I'm importing into column 1 works just fine with this code:
But when I try to do something very similar in column L, the data gets written into column L, but the current contents of cells L1-L12 get moved to M1-M12. Here is the part of the code that is giving me trouble.
What can I do to get the data in cells L1-L12 to stay put when I run this code?
Thanks!
Code:
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;" & TempFolder & "\File1.CSV", Destination:=Sheet1.Cells(13, 1))
.Refresh BackgroundQuery:=False
End With
But when I try to do something very similar in column L, the data gets written into column L, but the current contents of cells L1-L12 get moved to M1-M12. Here is the part of the code that is giving me trouble.
Code:
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;" & TempFolder & "\File2.CSV", Destination:=Range("L13"))
.Refresh BackgroundQuery:=False
End With
What can I do to get the data in cells L1-L12 to stay put when I run this code?
Thanks!