Formatting a detail line while printing with FileSystemObject?
Posted on 2006-11-16
I am creating a .txt file. I need to have each column fixed length. I am using the FileSystemObject where my final detail line is produced by the following line of code:
strLine = strLocID & " " & strVendID & " " & strDateTime & " " & strProdID & " " & strPrice
The file is created with no problem, however, the columns, row for row, do not line up exactly...meaning each column does not start in the exact column each time.
How can I fix this?