Hi Snd:

I tried the following but its giving Compile Error "Syntex error"

I have opened the txt file and it is located "C:\TEST.txt".

I run the above vb Code in excel but it gives error.

Please have a look and help...Thanks

RM