Comment and Tab character

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

Guest

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 the
file in Notepad the Table/field names line up nicely. How do I make this
happen when the text is placed into a comment.

Range(sCell).Comment.Text Text:=sSQLtext
sSQLtext is read in with OpenTextFile and a .ReadAll

I have the comment shape resizing automatically but I am getting unprintable
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.
 
Consider an alternative:

How about putting the comment text into small embedded Word Objects?
Formatting is much easier in Word and, in the end, might be less trouble for
you.
 
John,
How about using a fixed width font and Replace Chr(9) with x number of
spaces.

NickHK
 
Back
Top