I am placing into a cell comment the Text value from a file. (it happens to
be some short SQL program statements)
In the *.SQL file tab chars CHR(9) have been stored so that when viewing
file in Notepad the Table/field names line up nicely. How do I make this
happen when the text is placed into a comment.
sSQLtext is read in with OpenTextFile and a .ReadAll
I have the comment shape resizing automatically but I am
characters showing as a box. CHR(10) works properly to line break. But 9s
and 13s are showing as the unprintable default box-character. I figure I can
just relpace the 13's with a space CHR(32).. but for the 9's that will change
the appearance of the text.
Is there a setting that will make the CHR(9) actually tab to a position with
in the comment text box?
I was hoping to not have to use the "brute-force" method and process the
text character by character storing when a new line starts and count the
characters to know exactly how many spaces to replace the CHR(9) with.