Fixed Width

[Guest]

Thanks for taking the time to read my question.

I'm working with a fixed width text file. I want to add x number of spaces
after my value without having to do a loop. Is there a good way to do this?

I'm using Print #1, Sheets(SheetName).Cells(RowNum, 1) & " " &
Sheets(SheetName).Cells(RowNum, 2) to write to the file. So I can use
len() to get the len of the value and then just add x spaces to make up the
difference.

Thanks,

Brad

 

[Guest]

the VBA string function does exactly what you want it to do. let the
character be " "

Returns a Variant (String) containing a repeating character string of the
length specified.

Syntax

String(number, character)

 

[Guest]

Perfect!!! Thanks Joel

Have a great day.

Brad

the VBA string function does exactly what you want it to do. let the
character be " "

Returns a Variant (String) containing a repeating character string of the
length specified.

Syntax

String(number, character)