Recent content by tmangin

Swi, Thanks for your help. I actually used a version of what you suggested. Thanks!

DrJavaJoe, Your suggestion worked like a charm! Thanks so much for your help.

I'm running a program that returns output to a text file (notepad). Each line of output contains a four digit ID, name of client, number of times ID is in the file, and an amount. For example: 2701 RADIOLOGY CONSULTANTS, INC. 2 3,225,228.00 2710 TEST 1 190.00 2607...

JeffTullin, Thanks for your reply. I'm not really sure that I follow what you said, though. What does non-starter mean? Also, what data do you need to see? I will be more than happy to provide you with it. The source file cannot be a text file because it has to be set up as some type of...

Hi, I need to write code that will open a file, either in Word or Excel, read through the table and when it finds the number it's looking for, grabs the corresponding text and returns it to the code to be further manipulated. Any help or suggestions would be greatly appreciated! Thanks!

Thanks DrJavaJoe, mattKnight, johnwm, and Golom for all of your help and suggestions. I'm all fixed!

BiggerBrother & DrJavaJoe, I tried both of your suggestions, but with each, nothing happens. The file is not created. In fact, it seems to freeze. I appreciate you sending the additional thread as well, however, I was hoping there would be a simpler way to do this. Any other suggestions...

Does anyone know how to name a file with the current date? I'm creating the text file this way: Open "C:\iFtpSvc\Hms-ftppro\users\RCI27\Report.txt" For Output As 2 Instead of Report.txt, I want the name of that file to be the current date. Thanks!

Thank you both for your replies...they were both very helpful!

Hi, I need to open a text file for Input, then open another text file to write output to. Is this possible in a single VB app (.exe)? Below is a sample of what I have right now, however, I'm having problems with it. Public Sub Form_Load() Open...

Hi, I need to open a zip file that will contain a .txt file that I need to read and manipulate with VB6. It's all got to be automatic. Has anyone done this before or have any knowledge or experience with doing this?? Any help would be greatly appreciated! Thanks!

paulbent and vbSun, Thanks so much to both of you for your help. I think I am going to use paulbent's suggestion. paulbent- I've got one more question. Right now, I'm getting an extra "occurred 0 times" in the beginning of my output. I think I know why: The text file I'm reading...

paulbent, Thanks so much for the response. It works, however, all of the counts for each ID are one less than they should be. Do you have any idea why this is happening? Thanks!

vbSun, I think I follow your idea, but in order to use the same methodology to find the ID's, do I have to search for a specific ID? I don't know the ID's to search for...just know that they are n characters after the pipe char. Thanks!

paulbent, I appreciate your help, but the DupCount is not working. It gives me zero for each ID. Thanks!