I need a program in VB6 to take the text file called [url removed, login to view] and put it into excel (see [url removed, login to view]) formatted like after.xls.
The bottom part that has "stat" letters has to be in a column by itself. See N244:O244 in after.xls. The text file has these 2 items together but they must be broken apart in the after.xls.
I have tried to directly import it (the text file) into excel but can't figure out a way to get the "stat" letters to go in their own column. Also, I need the blank "gutter" columns to be added in the [url removed, login to view] to separate each column. This gutter column should be 1 char wide (see cols D, G, J in [url removed, login to view]).
I also need to have a drive/folder/file control on the form so the user can navigate to the proper text file.
This application has to work for any text file, not just my example before.txt. All the text files that the user will select will be similar to the [url removed, login to view] file example.
Please email me questions.
I need this ASAP. Thank you
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Must operate on w95, w2000, wxp, win nt
Must work with excel 97, excel 2000, excel 2002