Formatted output to text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know there is a simple answer to this, but I can't seem to find it in the
help file. I am using the VBA print# statement to create a text file with
numbers in right justified columns. One of the columns will contain a
floating point value and I need to contol the output width of this so it
lines up correctly. I don't want to use a fixed decimal point format because
the output number might be anywhere in the range of 100000+ to less than 1,
so I need to control the output to a fixed number of significant figures. I
am sure there's a parameter where you can set the width of an output string,
but I can't find it. Can anyone help?

Thanks
 
Simon:

You can use spc(x) or tab(x).

In your situation it is probably easier to print the integer part and then
the decimal.
using format to get the right spacing.
 
Back
Top