WIDTH # filenumber, width

Assigns an output line width (characters) for the open file.

filenumberThe number of the file (Integer).
widthThe number of characters (0 to 255) (Integer).

* The width indicates how many characters appear on a line before a new line is started.
* For the Microsoft documentation refer to learn.microsoft.com

VBA.Open "MyFile" For Output As #1 
Width 1, 5

Dim iCount As Integer
For iCount = 1 to 10
   VBA.Print #1, Chr(48 + iCount)
Next iCount
VBA.Close #1

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top