VBAnovice43
MIS
Anyone know how to convert an Excel file to a text file with this format?
015P3212384351351351
...
...
Each line has fixed positions that represent some type of date like a date, a check number, etc...
The Excel file is in a template form where the first column is for a check#, the second an issued date, and the third column asking for the amount. Would a "Line Input" work with an EOF statement to read the excel file?
015P3212384351351351
...
...
Each line has fixed positions that represent some type of date like a date, a check number, etc...
The Excel file is in a template form where the first column is for a check#, the second an issued date, and the third column asking for the amount. Would a "Line Input" work with an EOF statement to read the excel file?