Then read on. Oh, and thanks to Rockford Lhotka's, book on Visual Basic 6 Business Objects for giving me this idea. Failure to do so is a violation of copyright laws. Ok, the line above represents lets say one of a few hundred lines. Code Alpha 37 A for accepted, R for rejected Account AlphaNumeric 38-43 First thing is to create a user defined type representing the layout of the file.
All types are strings reguardless of the type in the file.
This will become clearer later. As udtInput ' Open your file for reading Open App. Convert numeric String Amount value to a Long value with 2 decimal places Debug. Note - The MyDateFunction is a function you define ' to parse the date string to the proper format you want. Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time.