Hi all

I have a text tablimited file in c:\excel macros folder with the following
format. Please let me know how I can read that file from that folder and to
store in a vriable

1 Description1
2 Description2
3 Description3
4 Description4



Columns("P:P").Select
Range("P1").Activate

Selection.Replace What:="1", Replacement:="Description1",
LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

Selection.Replace What:="2", Replacement:="Description2",
LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

With Regards

Pol