wtawta

Kevin, I tried to use this sample you provided and failed to get it to work. I was left with the 'testBACK.txt' file in the C drive and not the 'test.txt' file. I took a look into the commands and noticed that there were some file paths missing. For example, in some of the file path fields it reads 'test.txt' instead of 'c:\test.txt'. I am assuming this was an oversight so I added the file path to the appropriate areas of the macro. For some reason I am not ending up with the desired result intended (I think). I believe the desired result of your macro is a 'test.txt' file with all the email/pass pairs minus the first pair in the original list. Instead, I am ending up with a 'testBACK.txt' file with all the original email/pass pairs. Nothing removed from the original document and no 'test.txt' file. Am I missing something?

Kevin, thanks for taking time to help. This is how we currently keep track of which email/pass pair is next in line to be used. We would like to change this method in order to keep this list clean (free of used pairs).

It is necessary for this 'moving' to occur if this is to work in my project. I could give a explanation why but it would probably take me a day. lol. "Get and process T1 and T2 for line 1 of the text file" makes sense and works perfectly. I have edited the macro you posted a bit to just get and process T1 and T2 for line 1 of the text file and not to loop and process the rest of the lines. The next time I run this new macro it will process line 1 again and return the same information for T1 and T2 unless I can remove the original data of line 1, in this case T1 and T2 from the original text document. I can't (would rather not) keep track of which lines have been processed before hand, in order to get the next email/pass the next time I run this macro. I guess what I need to know are two things. How to delete the first line of text from a document, in this example an email address and password. I am assuming deleting this email/pass will leave a empty space in line 1 of the text document. If this is the case, the second thing I would need is to move the next email/pass up to the top (line 1) of the text document. Now, the next time the macro is run it will get a and process the T1 an T2 for line 1 and it will return the new values (email/pass) that were not returned the last time I ran the macro. I hope I am making sense. Thanks so much.

Terry, my partner "webbhogg" is the original poster of the thread. Thanks for you assistance, you answered something we've been trying to wrap our heads around for a while. Let me try to clear up what was meant by replacing line 1 with line 2. We will be processing the file and capturing the email /password one at a time. After we have the first email/pass we would like to remove it from the .txt file and bring the next email/pass up to line value 1. This way whenever the we need to get the next email/pass it will always be located on the first line (line value 1) of the text document. For example the text document may start with this data: name1@email.com:pass1 <--- (Line value = 1 of text doc.) name2@email.com:pass2 name3@email.com:pass3 name4@email.com:pass4 name5@email.com:pass5 Then we will call for the first email/pass leaving the text document like this: name2@email.com:pass2 <--- (Line value = 1 of text doc.) name3@email.com:pass3 name4@email.com:pass4 name5@email.com:pass5 and, so on: name3@email.com:pass3 <--- (Line value = 1 of text doc.) name4@email.com:pass4 name5@email.com:pass5 I hope this is clearer. Please let me know and thanks again for you help!

Can't seem to wrap my head around making this work the way I want. Simple for some of you so I hope you can help? I want to run a macro every "X" occurances of an event. Let me try to explain in more detail and as simply as I can. Every "5" times a "Notepad" window is opened I want to run my macro. I would like to be able to change the number from 5 to whatever number I want of course. So I'm thinking that every time Notepad is opened, one macro is counting each event and logging it in a variable and everytime that veriable equals my number, in this case "5", another macro is triggered??? If I'm on the right track so far then I realize that my triggered macro will need to reset that veriable from 5 back to zero somehow in order to repeat the after another 5 instances. Hope this makes sense and you can help me out.