Help! I have a VBA macro where I am creating an output text file. I have to correctly space the entries of each line.
Is there a function to add spaces to an output line?
For example here is part of the code
For i = 10 To 39
iENUM = i
iEN1 = i
iEN2 = i + 1
Print #intFH, Space(4), iEN1, Space(4), iEN2, Space(41), "1", Space(5), "1", Space(5), "1", Space(5), "1", Space(10), iENUM
Next i
I have iENUM,iEN1, and iEN2 dimensioned as integers. Right now I am getting way too many spaces between entries in the line.
Is the Space command the culprit?
Any help is greatly appreciated
Is there a function to add spaces to an output line?
For example here is part of the code
For i = 10 To 39
iENUM = i
iEN1 = i
iEN2 = i + 1
Print #intFH, Space(4), iEN1, Space(4), iEN2, Space(41), "1", Space(5), "1", Space(5), "1", Space(5), "1", Space(10), iENUM
Next i
I have iENUM,iEN1, and iEN2 dimensioned as integers. Right now I am getting way too many spaces between entries in the line.
Is the Space command the culprit?
Any help is greatly appreciated