Thank you very much!! this actually works.. my only issue though is that the text file I have is what i have just sent but repeated a million times. So it would be really hard for me to separate each line. is there any way I can separate/parse this text file through vba before proceeding to the code you have sent me?